SQLSERVER 指针|写法|语法|例子

declare @idno int ,@value nvarchar(10)
declare my_cursor cursor for
  select * from dbo.split('123,1456',',')
open my_cursor
fetch my_cursor into @idno,@value
while @@FETCH_STATUS=0
begin
 print @value
fetch my_cursor into @idno,@value;

end
close my_cursor;
deallocate my_cursor

SQLSERVER 指针|写法|语法|例子

转载于:https://www.cnblogs.com/wangdetian168/archive/2011/04/29/SQLSERVER-cursor.html