DECLEARE @name VARCHAR(20)
DELCARE @age INT
DECLARE myCursor CURSOR for SELECT name,age FROM users WHERE age BETWEEN 40 AND 50
OPEN myCursor
FETCH NEXT FROM myCursor INTO @name, @age
WHILE(@@FETCH_STATUS = 0)
BEGIN
INSERT oldmanuser (name,age)values(@name,@age)
END
CLOSE myCursor
DEALLOCATE myCursor
这个游标解释
myCursor是游标名称
循环从users表中取出年龄在40和50岁之间的用户
插入到oldmanuser 表中。
@@FETCH_STATUS 变量值是0 说明游标中有数据 WHILE循环继续
游标格式是
DECLARE 游标名
OPEN 游标
FETCH NEXT 抓数据 into 到变量中
WHILE 循环FETCH
执行处理后
Close游标
deallocate释放游标