fetch next from abc into @a,@b 取到值后,定义两个临时变量@i,@j,保存@a、@b的值修改@a、@b的值后,用Update语句更新回数据库如: update 表名 set 字段1=@a,字段2=@b where 字段1=@i and 字段2=@j
可以使用WHERE CURRENT OF 游标名 来更新游标的当前行.举个SQL帮助里的例子: USE Northwind GO DECLARE abc CURSOR FOR SELECT CompanyName FROM Shippers OPEN abc FETCH NEXT FROM abc UPDATE Shippers SET CompanyName = N'Speedy Express, Inc.' WHERE CURRENT OF abc CLOSE abc DEALLOCATE abc
update 表名 set 字段1=@a,字段2=@b where 字段1=@i and 字段2=@j
USE Northwind
GO
DECLARE abc CURSOR FOR SELECT CompanyName FROM Shippers
OPEN abc
FETCH NEXT FROM abc
UPDATE Shippers SET CompanyName = N'Speedy Express, Inc.'
WHERE CURRENT OF abc
CLOSE abc
DEALLOCATE abc