创建游标出错?
我在isql下执行以下的批命令时报错:
declare cursor must be the only statement in a query batch.
declare @login varchar(2)
declare cur_1 cursor for
select name from master.dbo.syslogins where dbname='ycds'
open cur_1
fetch cur_1 into @login
while (@@sqlstatus =0)
begin
exec sp_addalias @login,'dbo'
fetch cur_1 into @login
end
close cur_1
deallocate cursor cur_1
go
请问是什么原因呀?