Error with Declare usage

Question

I would like to learn how to use declare.

My query is like:

declare @iter int
set @iter = 1

error:

Msg 137, Level 15, State 1, Line 1 Must declare the scalar variable "@iter".

Please help!

Select everything then run your script. If you run the declaration part and then run the set part you will get an error. — BICube, Jun 19 '15 at 21:47

score 0 · Answer 1 · edited Jun 19 '15 at 20:40

0

That can be done in one or two lines:

declare @iter int = 1
go 
-- or
declare @iter int 
set @iter = 1

edited Jun 19 '15 at 20:40

Ken White

answered Jun 19 '15 at 20:39

Chuck

score 0 · Answer 2 · answered Jun 19 '15 at 20:39

0

You just need to put thw two instructions in different lines

declare @iter int
set @iter = 1

answered Jun 19 '15 at 20:39

Julio Elgueta

They were on two separate lines, the OP just didn't format their code properly so it looked like it was on a single line – LittleBobbyTables - Au Revoir Jun 19 '15 at 20:40

score 0 · Answer 3 · answered Jun 24 '15 at 20:15

0

I execute these two line separately that's why it won't work cause before I execute set @iter = 1, SQL have cleared the declare command.

answered Jun 24 '15 at 20:15

user2565838

3 Answers3