例子table1结构如下id
intnamevarchar(50)declare @id intdeclare @name varchar(50)declare cursor1 cursor for
--定义游标cursor1select * from table1
--使用游标的对象(跟据需要填入select文)open cursor1
--打开游标fetch next from cursor1 into @id,@name--将游标向下移1行,获取的数据放入之前定义的变量@id,@name中whi...