SQL游标

接 sql触发器，视图等

declare @name nvarchar(100) ,@stat int
declare ctest1 cursor scroll for –游标
select bkname,stat from books
open ctest1
fetch next from ctest1 into @name,@stat
while (@@FETCH_STATUS=0)
begin
–select @name ,@stat
if (LEFT(@name,1)=’三’)
begin
select @name+’,’+cast(@stat as varchar(10))
end
–update books set bkname=’三国’ where bkname=’三国1′
fetch next from ctest1 into @name,@stat
end
close ctest1
deallocate ctest1;