DECLARE vend_cursor CURSOR FOR SELECT * FROM Purchasing.Vendor OPEN vend_cursor FETCH NEXT FROM vend_cursor
2,declare mycursor cursor for update 这个语法是怎样的 ? 没有这样的定义游标
DECLARE c1 CURSOR FOR SELECT au_id, au_lname FROM authors FOR UPDATE OF au_lname
Cursors: An Overview http://www.sqlteam.com/article/cursors-an-overview
1.declare mycursor cursor for select @id ... 这个参数怎么设置的?突然忘记了, 游标的select语句中不能使用变量,只能在后面的提取某条记录时使用 例: declare @id int, @name varchar(20) declare mycursor cursor for select id,name from tbl open mycursor fetch next from mycursor into @id,@name ...........2.declare mycursor cursor for update 例:declare mycursor cursor for select id,name,age from tbl for update --表示表tbl中的三列都可以更新 declare mycursor cursor for select * from tbl for update of id,name --表示只能更新表tbl中的id,name两列
http://msdn.microsoft.com/zh-cn/library/ms180169.aspx
declare mycursor cursor for select .........
FOR SELECT * FROM Purchasing.Vendor
OPEN vend_cursor
FETCH NEXT FROM vend_cursor
2,declare mycursor cursor for update 这个语法是怎样的 ? 没有这样的定义游标
SELECT au_id, au_lname
FROM authors
FOR UPDATE OF au_lname
http://www.sqlteam.com/article/cursors-an-overview
游标的select语句中不能使用变量,只能在后面的提取某条记录时使用
例:
declare @id int, @name varchar(20)
declare mycursor cursor for select id,name from tbl
open mycursor
fetch next from mycursor into @id,@name
...........2.declare mycursor cursor for update
例:declare mycursor cursor
for select id,name,age from tbl for update --表示表tbl中的三列都可以更新 declare mycursor cursor
for select * from tbl for update of id,name --表示只能更新表tbl中的id,name两列