In-line variable assignment 2

Question

Post reply

In-line variable assignment 2

Hugo Kornelis

SSC Guru

Points: 64790
More actions
August 10, 2014 at 1:23 pm

#288906

Comments posted to this topic are about the item In-line variable assignment 2
Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/
August 11, 2014 at 2:42 am

This was removed by the editor as SPAM

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

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

mickyT SSChampion Points: 10360 More actions · Answer 1

mickyT

SSChampion

Points: 10360

August 10, 2014 at 1:24 pm

#1736678

Good question thanks

Hany Helmy SSChampion Points: 13921 More actions · Answer 2

Easy but good one, thx Hugo.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

Great question Hugo, and a very good explanation.

Thanks.

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

sektor81 Say Hey Kid Points: 679 More actions · Answer 4

This is rather odd behavior since @j-2 belongs to BEGIND/END section. In C#, for instance, this would result error.

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 5

Nice sample to spot the behavior, thanks for putting it together.

I wander if this is supposed to work like this, or is actually a bug.

Toreador SSChampion Points: 11365 More actions · Answer 6

This should be easy for anyone who's been following the discussion about part 1 of this question!

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

Umer Akram

SSC-Insane

Points: 22209

August 11, 2014 at 4:25 am

#1736765

Nice question Hugo Thanks for sharing

palotaiarpad SSCertifiable Points: 5617 More actions · Answer 8

I'm happy with the explanation, but feeling confused due to BOL:

After declaration, all variables are initialized as NULL, unless a value is provided as part of the declaration.

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

Mr. Kapsicum

SSCertifiable

Points: 6128

August 11, 2014 at 4:59 am

#1736781

Good One. Thanks

Ed Wagner SSC Guru Points: 287026 More actions · Answer 10

Thanks for a nice question. It's unclear from what I've read in the MS docs, but so are a lot of things, so thanks for the good explanation.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

TomThomson SSC Guru Points: 104773 More actions · Answer 11

Nice question.

One of the many things that are not adequately documented by Microsoft, but which people eventually learn from other people or from experimenting or from discovering it the hard way.

Tom

SqlMel SSCrazy Points: 2901 More actions · Answer 12

Thanks, Hugo.

Good follow-up to the previous question.

---------------
Mel. 😎

sestell1 SSChampion Points: 10230 More actions · Answer 13

sestell1

SSChampion

Points: 10230

August 11, 2014 at 6:45 am

#1736827

Great question, thanks Hugo!