DECLARE Cur CURSOR
FOR select AccID from #AccData3
OPEN Cur
FETCH NEXT FROM Cur INTO @AccID
WHILE @@FETCH_STATUS =0
BEGIN
END
--关闭游标
CLOSE Cur
--释放资源
DEALLOCATE Cur
sql游标使用
最新推荐文章于 2024-10-09 22:03:16 发布
DECLARE Cur CURSOR
FOR select AccID from #AccData3
OPEN Cur
FETCH NEXT FROM Cur INTO @AccID
WHILE @@FETCH_STATUS =0
BEGIN
END
--关闭游标
CLOSE Cur
--释放资源
DEALLOCATE Cur