Why does this not work (declare and go)

Fatbob73 · #1 (**permalink**) 02-05-10, 10:27

Hi everyone,

Can someone tell me why the following those note work...

Code:

declare @testing int
go

select @testing = 1
go

select @testing
go

It complains that I must declare variable '@testing'.

But this those work...

Code:

declare @testing int
select @testing = 1
select @testing
go

In a nutshell I'm trying to write a script that is using a cursor, and it seems that to be able to use a cursor in a script I need to have 'go' after all statements.

Thanks!

MCrowley · #2 (**permalink**) 02-05-10, 11:00

"go" is the batch terminator. It separates logical groupings of SQL statements.

Internet Services

Web Development

Digital Marketing

Consumer Tech