摘要: 近期又看到头疼的cursor的问题。把游标重新整理下吧 1 declare @id varchar(50); 2 declare @Title varchar(50); 3 declare @Director varchar(50); 4 declare @DateReleased varchar(50); 5 6 declare mycursor cursor for --定义一个游标 7 select * from movies --游标的可循环对象 8 open mycursor --打开游标 9 fetch next from mycursor into @id,@Title,@Dir 阅读全文
posted @ 2011-05-11 14:37 Shikyoh 阅读(208) 评论(0) 推荐(0) 编辑