sql游标
发布时间：2008-11-28 22:51:00 作者：admin 阅读：1021次DECLARE @username varchar(100)
DECLARE myCusor CURSOR FOR
select username from username
OPEN myCusor
FETCH NEXT FROM myCusor INTO @username
WHILE @@FETCH_STATUS = 0
BEGIN
print @username
FETCH NEXT FROM myCusor INTO @username
END
CLOSE myCusor
DEALLOCATE myCusor
DECLARE myCusor CURSOR FOR
select username from username
OPEN myCusor
FETCH NEXT FROM myCusor INTO @username
WHILE @@FETCH_STATUS = 0
BEGIN
print @username
FETCH NEXT FROM myCusor INTO @username
END
CLOSE myCusor
DEALLOCATE myCusor
如有问题，可以QQ搜索群1028468525加入群聊，欢迎一起研究技术
有疑问联系站长，请联系QQ：
上一篇：actionscript
下一篇：触发器
转载请注明：sql游标 出自老鄢博客 | 欢迎分享