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
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About Denis Gobo
I was born in Croatia in 1970, when I was one I moved to Amsterdam (and yes Ajax is THE team in Holland) and finally in 1993 I came to the US. I have lived in New York City for a bunch of years and currently live in Princeton, New Jersey with my wife and 3 kids. I work for Dow Jones as a Database architect in the indexes department, one drawback: since our data goes back all the way to May 1896 I cannot use smalldates ;-(
I have been working with SQL server since version 6.5 and compared to all the other bloggers here I am a n00b.
Some of you might know me from http://sqlservercode.blogspot.com/ or even from some of the newsgroups where I go by the name Denis the SQL Menace
If you are a Tek-Tips user then you might know me by the name SQLDenis, I am one of the guys answering SQL Questions in the SQL Programming forum.