Declare @local variable

Question

Post reply

Declare @local variable

steve.jacobs

SSCommitted

Points: 1830
More actions
December 4, 2013 at 10:13 pm

#285737

Comments posted to this topic are about the item Declare @local variable
December 5, 2013 at 1:03 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 24 total)

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

Mr. Kapsicum SSCertifiable Points: 6128 More actions · Answer 1

easy one for the guys who has past experience in 2005

Umer Akram SSC-Insane Points: 22209 More actions · Answer 2

Umer Akram

SSC-Insane

Points: 22209

December 4, 2013 at 10:46 pm

#1670915

i almost clicked on "YES".

Thanks for sharing

philip.cullingworth SSCrazy Points: 2150 More actions · Answer 3

Mr. Kapsicum (12/4/2013)
easy one for the guys who has past experience in 2005

And those with current experience of 2005:-)

paul s-306273 SSChampion Points: 10730 More actions · Answer 4

paul s-306273

SSChampion

Points: 10730

December 5, 2013 at 1:35 am

#1670945

Easy (maybe too easy?).

SQLDoubleG Hall of Fame Points: 3100 More actions · Answer 5

SQLDoubleG

Hall of Fame

Points: 3100

December 5, 2013 at 1:43 am

#1670949

Thanks for the easy one!

Arthur Olcot SSCertifiable Points: 6719 More actions · Answer 6

Love the "maybe" option! made me think twice before answering

steve.jacobs SSCommitted Points: 1830 More actions · Answer 7

paul s-306273 (12/5/2013)
Easy (maybe too easy?).

Well I thought I would give an easy one to "make up" for the "Order My Data" question I submitted. But you would be surprised how many developers get this one wrong. :w00t:

OCTom SSChampion Points: 11785 More actions · Answer 8

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

Carlo Romagnano SSC-Insane Points: 22737 More actions · Answer 9

Starting from sqlserver2008, you can declare and set a variable in one statement,

but you can NOT initialize a second variable with another inside the same declaration.

declare @a varchar= 'A'

,@b varchar= @a

You should have two DECLARE

declare @a varchar= 'A'

declare @b-2 varchar= @a

Ken SSCoach Points: 17191 More actions · Answer 10

I had to do some research on this one because we jumped from 2000 to 2008. Like many others, I have always set my variables in separate SET statements anyway. It wasn't until I saw someone else's code on a 2008 instance a couple years ago that I saw a value set in the declaration. Thanks for the question Steve!

steve.jacobs SSCommitted Points: 1830 More actions · Answer 11

Carlo Romagnano (12/5/2013)
Starting from sqlserver2008, you can declare and set a variable in one statement,
but you can NOT initialize a second variable with another inside the same declaration.
declare @a varchar= 'A'
,@b varchar= @a
You should have two DECLARE
declare @a varchar= 'A'
declare @b-2 varchar= @a

Absolutely true Carlo. Simple reason, query "parser"\optimizer has no idea what @a is. So you are setting it before declaring it (backwards). This is seen in many (if not all) programming languages.

Thanks

Jason Wolfkill SSCrazy Eights Points: 9832 More actions · Answer 12

Ahh, this brought back bad memories of all the extra typing required to declare and set variables in separate statements. I still say a silent "hallelujah" every time I declare and set a variable in the same statement.

Jason Wolfkill

Dave62 SSCertifiable Points: 7459 More actions · Answer 13

I got it right but only by guessing if the question was to be answered or the description.

The problem is that, as written, the question and the description have 2 different answers.

In SQL Server 2005, is the code segment (a local variable in a stored procedure) below allowed?

The question "In SQL Server 2005, is the code segment below allowed?" has one answer.

The description "(a local variable in a stored procedure)" has a different answer.

In order for the description to match the question it would have to read "(a local variable, declared and set in one line, in a stored procedure)".

I don't see too many complaints though so maybe I'm the only one who thought there could be a trick in the wording.

Thanks for the QotD!

Declare @local variable

Cookies on SQLServerCentral