MSSQL存储过程中获取记录集并循环操作一例

Create PROCEDURE my_sql
AS
	declare @id int,@loginname varchar(20),@website varchar(100)
	declare rs cursor for select top 50 id,loginname,website from union_user
	
	open rs
	fetch next from rs
	into @id,@loginname,@website
	while @@fetch_status=0
	begin
		print convert(varchar,@id) + ',' + convert(varchar,@loginname) + ',' + convert(varchar,@website)
		fetch next from rs
		into @id,@loginname,@website
	end
	close rs

	deallocate rs
GO