Without running this what do you think will be printed? SET ROWCOUNT 0DECLARE @ intSET @ =6IF @@ROWCOUNT = 1    PRINT 'yes'ELSE    PRINT 'no'PRINT @@rowcount

This one is a little sneaky, don’t send me hate mail for it. What does this return?   SELECT ISNUMERIC('+'),ISNUMERIC('–') Copy and paste it into QA/SSMS to verify  :-0    

You have a table where hours are stores as integers and you need to display it in weeks, days and hoursIf you have the following table CREATE TABLE #Hours (hours int)INSERT INTO #HoursSELECT 5 UNION ALLSELECT 55 UNION ALLSELECT 125 UNION ALLSELECT 1225 UNION ALLSELECT 555 UNION ALLSELECT 721 UNION ALLSELECT 719   The expected output is ...

This teaser was posted by my friend George on Tek Tips and I am posting it here after I asked for his permission. the main reason I am posting it here is because I want to get some opinions from the experts. Take a look at these two queries If 1/0 = 10 And 1/1 = 0 Select 'True' As Query1 Else Select 'False' As Query1   If 1/0 = 10 And ...

It has been a while since my last teaser but here we go What do you think the following returns? SELECT CONVERT(datetime,'1/1/1') -CONVERT(datetime,1) + CONVERT(datetime,0)   How about this on SQL Server 2008 SELECT CONVERT(datetime2,'1/1/1'),CONVERT(datetime2,'01/01/01'),CONVERT(datetime2,'0001/01/01') Now run this on SQL Server ...

This should trip up some people..... Without running this code what do you think will LEN and DATALENGTH return? DECLARE @i int SELECT @i =' 123456789 ' SELECT @i,LEN(@i),DATALENGTH(@i)

Print the @SQL variable without using PRINT DECLARE @SQL varchar(49) SELECT @SQL = 'Print This Now ' + CONVERT(VARCHAR(30), GETDATE()) --Your Code Here

Without running this code try to guess what the values of @var1 and @var2 will be CREATE TABLE #TeasMeNot(id int) DECLARE @var1 int,@var2 int SELECT @var1=0,@var2 = 0 SELECT @var1 =id FROM #TeasMeNot SELECT @var2 = (SELECT id FROM #TeasMeNot) --What is the value of @var1 and @var2? SELECT @var1,@var2 DROP TABLE #TeasMeNot  

What will happen when you run this? Create Table #Dots(Data VarChar(50)) Insert Into...#Dots Values('Huh?') --3 dots Insert Into..#Dots Values('Huh, say what?') --2 dots Select * From .#Dots -- 1 dot Drop Table #Dots --look no dots!

What do you think will be the output? DECLARE @d datetime SET @d = '20071010' SELECT DATEADD(yy, DATEDIFF(yy, 0, @d)+1, -1)