THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Browse by Tags

All Tags » Teaser   (RSS)
Showing page 1 of 3 (26 total posts)
  • SQL Teaser: @@ROWCOUNT

    Without running this what do you think will be printed? SET ROWCOUNT 0DECLARE @ intSET @ =6IF @@ROWCOUNT = 1    PRINT 'yes'ELSE    PRINT 'no'PRINT @@rowcount
    Posted to Denis Gobo (Weblog) by Denis Gobo on May 8, 2008
  • SQL Teaser: Some Things Are Not What They Seem

    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    
    Posted to Denis Gobo (Weblog) by Denis Gobo on April 25, 2008
  • SQL Puzzle: Hours Stored As Integers

    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 ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on April 14, 2008
  • George's Division Teaser

    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 ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on January 17, 2008
  • Yet Another Date Teaser

    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 ...
    Posted to Denis Gobo (Weblog) by Denis Gobo on January 10, 2008
  • SQL Teaser: LEN vs DATALENGTH

    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)
    Posted to Denis Gobo (Weblog) by Denis Gobo on December 12, 2007
  • SQL Teaser: Printing Without Using PRINT

    Print the @SQL variable without using PRINT DECLARE @SQL varchar(49) SELECT @SQL = 'Print This Now ' + CONVERT(VARCHAR(30), GETDATE()) --Your Code Here
    Posted to Denis Gobo (Weblog) by Denis Gobo on November 9, 2007
  • SQL Teaser: Select

    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  
    Posted to Denis Gobo (Weblog) by Denis Gobo on October 24, 2007
  • Dot Doesn't Make Sense?

    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!
    Posted to Denis Gobo (Weblog) by Denis Gobo on October 18, 2007
  • 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)
    Posted to Denis Gobo (Weblog) by Denis Gobo on October 10, 2007
1 2 3 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement