THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Teaser » NULL » COALESCE   (RSS)
Sorry, but there are no more tags available to filter with.
  • Summer SQL Teaser #2 NULL vs COALESCE

    Without running the code, try to guess the output   DECLARE @v1 VARCHAR(3) DECLARE @i1 INT     SELECT  ISNULL(@i1, 15.00) /2,       COALESCE(@i1 , 15.00) /2,       ISNULL(@v1, 'Teaser #2'),       COALESCE(@v1, 'Teaser #2') I hope you will ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on June 8, 2007
Privacy Statement