一个简单的带游标的存储过程

CREATE PROC UpdateStuAge@setAge int ASBEGINDECLARE my_cursor CURSOR FOR SELECT ID,name,age FROM STUOPEN my_cursorDECLARE @ID varchar(50)DECLARE @NAME VARCHAR(50)DECLARE @AGE INTFETCH NEXT FROM my_cursor INTO @ID,@NAME,@AGEWHILE @@FETCH_STATUS=0BEGINIF(@setAge>@AGE)UPDATE STU SET age=@setAge WHERE id=@ID AND name=@nameFETCH NEXT FROM my_cursor INTO @ID,@NAME,@AGEENdCLOSE my_cursorDEALLOCATE my_cursorEND