T-SQL

Question

Post reply

T-SQL

Anju Renjith

Ten Centuries

Points: 1135
More actions
December 19, 2014 at 12:09 am

#299580

Comments posted to this topic are about the item T-SQL
December 19, 2014 at 6:43 am

This was removed by the editor as SPAM

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

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

Erwin Oosterhoorn SSCrazy Points: 2314 More actions · Answer 1

Erwin Oosterhoorn

SSCrazy

Points: 2314

December 19, 2014 at 2:40 am

#1765634

Nice and easy...

l.vignando Old Hand Points: 313 More actions · Answer 2

I tried on Sql 2005,

Msg 139, Level 15, State 1, Line 0

Cannot assign a default value to a local variable.

Msg 137, Level 15, State 2, Line 4

Must declare the scalar variable "@str1".

Am I testing it in a wrong way?

SALIM ALI SSC Eights! Points: 859 More actions · Answer 3

the answer is only correct when using SqlServer 2012 and above. Previous versions prompt an error.

Erwin Oosterhoorn SSCrazy Points: 2314 More actions · Answer 4

l.vignando (12/19/2014)
I tried on Sql 2005,
Msg 139, Level 15, State 1, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Line 4
Must declare the scalar variable "@str1".
Am I testing it in a wrong way?

if you try this on 2005 you will need to split the variable assignment, try this:

@str1 VARCHAR(5)

,@str2 VARCHAR(10) ;

select @str1 = NULL, @str2 = 'SQL Strings';

Anju Renjith Ten Centuries Points: 1135 More actions · Answer 5

Anju Renjith

Ten Centuries

Points: 1135

December 19, 2014 at 3:52 am

#1765645

I use SQL Server 2008 R2 and it works fine..

serg-52 SSCrazy Eights Points: 9913 More actions · Answer 6

SALIM ALI (12/19/2014)
the answer is only correct when using SqlServer 2012 and above. Previous versions prompt an error.

2008 is quite enough.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 7

erwin.oosterhoorn (12/19/2014)
l.vignando (12/19/2014)
I tried on Sql 2005,
Msg 139, Level 15, State 1, Line 0
Cannot assign a default value to a local variable.
Msg 137, Level 15, State 2, Line 4
Must declare the scalar variable "@str1".
Am I testing it in a wrong way?
if you try this on 2005 you will need to split the variable assignment, try this:
@str1 VARCHAR(5)
,@str2 VARCHAR(10) ;
select @str1 = NULL, @str2 = 'SQL Strings';

In-line assignment was introduced in version SQL 2008

DECLARE

{

{ @local_variable [AS] data_type | [ = value ] }

| { @cursor_variable_name CURSOR }

} [,...n]

Prior to SQL 2008, declaration and assignment happens in two different lines.

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

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

While yes, initial assignment was introduced in SQL 2008, I think the point of the question was what it prints out and the data types involved. I thought it was a good question that raised a good point.

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