Browse by Tags

• dates
• Datetime
• NULL
• SQL Server 2005

• SQL Teaser: Guess the output

  What do you think will be the output? DECLARE @d datetime SET @d = '20071010' SELECT DATEADD (yy, DATEDIFF (yy, 0, @d)+1, -1) Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Read More... Posted Wednesday, October 10, 2007 11:46 AM by Denis Gobo | 6 Comments Filed under: Teaser, sqL Server 2000, SQL Server 2005, dates, Datetime

• SQL Teaser PASS Special: Table Size

  What will be the outcome of this script? First we create a table with a total of 6000 bytes Next we increase col2 from 1000 to 2000 bytes, this will give us a total of 7000 bytes Finally we add col3 which has 1000 bytes, this will give us a total of 8000 Read More... Posted Friday, September 21, 2007 9:58 AM by Denis Gobo | 4 Comments Filed under: Teaser, 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