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

CREATE PROC UpdateStuAge
	@setAge int 
AS
BEGIN
	DECLARE my_cursor CURSOR FOR SELECT ID,name,age FROM STU
	OPEN my_cursor
		DECLARE @ID varchar(50)
		DECLARE @NAME VARCHAR(50)
		DECLARE @AGE INT
	FETCH NEXT FROM my_cursor INTO @ID,@NAME,@AGE
	WHILE @@FETCH_STATUS=0
	BEGIN
		IF(@setAge>@AGE)
		UPDATE STU SET age=@setAge WHERE id=@ID AND name=@name
		FETCH NEXT FROM my_cursor INTO @ID,@NAME,@AGE
	ENd	
	CLOSE my_cursor
	DEALLOCATE my_cursor
END