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 指针|写法|语法|例子
