What is the result of the following query

Question

What is the result of the following query

Viewing 7 posts - 16 through 21 (of 21 total)

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

UMG Developer SSChampion Points: 13482 More actions · Answer 1

Thanks for the question, I have run into this before so I knew it right away.

TomThomson SSC Guru Points: 104773 More actions · Answer 2

Hugo Kornelis (12/10/2010)
(plus, that one is extremely unlikely, as the database for temporary object is called tempdb, not TempDB - but I guess only people who are in the habit of developing on a case sensitive instance would know that).

No, the case sensitivity makes no difference to the message displayed so even people like me who never use a case-sensitive instance are used to seeing "tempdb" in messages, and never "TempDB".

Tom

Abi Chapagai SSCrazy Points: 2666 More actions · Answer 3

Good question. Sometimes it is easy to miss small things and this type of questions will help us to keep up with the tips and tricks.

dfine Ten Centuries Points: 1251 More actions · Answer 4

good basic question.

Declare @strSql varchar(2000)

Set @strSql = ''

Set @strSql = @strSql + 'Create table #tmp (id int)'

Set @strSql = @strSql + 'Insert into #tmp(id) values (1) Select * from #tmp'

Exec (@strSql)

[font="Calibri"]Raj[/font]

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Thanks for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Enigma475 Ten Centuries Points: 1247 More actions · Answer 6

Enigma475

Ten Centuries

Points: 1247

December 21, 2010 at 8:10 am

#1265094

Very interesting question. Thank you!

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 7

Good Question.

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!