Declare @local variable

Question

Post reply

Declare @local variable

Viewing 10 posts - 16 through 24 (of 24 total)

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

Revenant SSC-Forever Points: 42467 More actions · Answer 1

Makes for tidier code, IMO. Thanks for the question, Steve!

Narud SSCrazy Points: 2837 More actions · Answer 2

Narud

SSCrazy

Points: 2837

December 5, 2013 at 12:33 pm

#1671291

Finally an easy question!

Thanks!

TomThomson SSC Guru Points: 104773 More actions · Answer 3

philip.cullingworth (12/5/2013)
Mr. Kapsicum (12/4/2013)
easy one for the guys who has past experience in 2005
And those with current experience of 2005:-)

And for those with no experience of 2005 who noticed the fanfares when this was announced for 2008.

Tom

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

Revenant (12/5/2013)
Makes for tidier code, IMO. Thanks for the question, Steve!

Agreed - thanks:hehe:

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

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 5

didn't need to think a second for the answer...

easy one ..

thanks steve

Hany Helmy SSChampion Points: 13921 More actions · Answer 6

Very easy one, already had a previous experience with this before.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Amit Raut SSCrazy Points: 2613 More actions · Answer 7

OCTom (12/5/2013)
The first SQL server version I worked with was 2000. I got into the habit of declaring and setting in two statements and I still do that today. I forgot you can declare and set in one statement. :crazy:
Tom

Me too

Rich Mechaber SSChampion Points: 11130 More actions · Answer 8

Finally - continued use of an older SQL release earns me easy points on QotD!

Rich

sqlnaive SSCoach Points: 17437 More actions · Answer 9

sqlnaive

SSCoach

Points: 17437

December 18, 2013 at 12:25 am

#1674294

Pretty easy one.

jfgoude SSCrazy Points: 2586 More actions · Answer 10

easy one

+1

just had a fear of a trick due to the maybe opt !!

Declare @local variable

Cookies on SQLServerCentral