SELECT @local_variable

Question

SELECT @local_variable

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

webrunner SSC-Dedicated Points: 31973 More actions · Answer 1

Great question, thanks.

- webrunner

-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 2

Easy one, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Scott-144766 SSCarpal Tunnel Points: 4333 More actions · Answer 3

Or you might get

Msg 208, Level 16, State 0, Line 7

Invalid object name '#values'.

if you have the misfortune to be working on a case-sensitive database.

--
Scott

Naidu PK SSCrazy Points: 2481 More actions · Answer 4

Scott-144766 (8/4/2015)
Or you might get
Msg 208, Level 16, State 0, Line 7
Invalid object name '#values'.
if you have the misfortune to be working on a case-sensitive database.

Awww!! Good point to know. I never thought about it.

Thanks,
Naveen.
Every thought is a cause and every condition an effect

SELECT @local_variable

Cookies on SQLServerCentral