|
|
|
|
Browse by Tags
All Tags » Teaser (RSS)
-
Today's teaser is very simple First create this table CREATE TABLE #Tran ( TranCountDefault int DEFAULT ( @@TranCount ), TranCountPassedIn int ) As you can see that table has two columns, one column has a default of @@TRANCOUNT. Now run this piece of Read More...
|
-
Take a look at this code, will the select return anything or not? Look at the subquery and notice that there is no FROM there. USE tempdb GO CREATE TABLE TestQuery ( TestID int ) GO SELECT * FROM information_schema.columns WHERE column_name =( SELECT Read More...
|
-
Try to guess what this WHERE clause is supposed to do. WHERE r . ApptId IS NULL AND r . DATE >= ISNULL (NULL , '1/1/1900' ) AND r . DATE < DATEADD ( d , 1 , ISNULL (NULL , '1/1/3000' )) AND --Filter on resource ( ( NULL IS NOT NULL AND r . DoctorResourceID Read More...
|
-
Create this table CREATE TABLE #bla (SomeVal uniqueidentifier) INSERT #bla VALUES ( 'D903D52D-DBFA-4904-9D95-F265152A391F' ) What do you think this will return? SELECT * FROM #bla WHERE SomeVal = 'D903D52D-DBFA-4904-9D95-F265152A391F12345678910' UNION Read More...
|
-
Without running this what do you think will be printed? SET ROWCOUNT 0 DECLARE @ int SET @ = 6 IF @@ROWCOUNT = 1 PRINT 'yes' ELSE PRINT 'no' PRINT @@rowcount Read More...
|
-
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 Read More...
|
-
You have a table where hours are stores as integers and you need to display it in weeks, days and hours If you have the following table CREATE TABLE #Hours (hours int) INSERT INTO #Hours SELECT 5 UNION ALL SELECT 55 UNION ALL SELECT 125 UNION ALL SELECT Read More...
|
-
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 = Read More...
|
-
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 , Read More...
|
-
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 ) Read More...
|
-
Print the @SQL variable without using PRINT DECLARE @SQL varchar ( 49 ) SELECT @SQL = 'Print This Now ' + CONVERT ( VARCHAR ( 30 ), GETDATE ()) --Your Code Here Read More...
|
-
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 Read More...
|
-
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! Read More...
|
-
What do you think will be the output? DECLARE @d datetime SET @d = '20071010' SELECT DATEADD (yy, DATEDIFF (yy, 0, @d)+1, -1) Read More...
|
-
Here is a small teaser, can you guess the output? SELECT d.c-d.b/d.a FROM ( SELECT 1 c,2 b,5 a)d(a,b,c) Read More...
|
|
|
|
|
|