Browse by Tags

• COALESCE
• sqL Server 2000
• SQL Server 2005

• Summer SQL Teaser #4 Nulls and Counts

  First create this table CREATE TABLE Teaser (ID int) INSERT Teaser VALUES (1) INSERT Teaser VALUES (2) INSERT Teaser VALUES (1) INSERT Teaser VALUES (2) INSERT Teaser VALUES (NULL) Without running this try to figure out what the result will be SELECT Read More... Posted Friday, June 22, 2007 10:45 AM by Denis Gobo | 7 Comments Filed under: Teaser, sqL Server 2000, NULL, SQL Server 2005

• 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 use COALESCE instead Read More... Posted Friday, June 08, 2007 5:46 AM by Denis Gobo | 2 Comments Filed under: Teaser, COALESCE, NULL