DECLARE cursor_fruit CURSOR FOR --创建游标
SELECT cs_id,cs_name FROM Base_Customer;
OPEN cursor_fruit --打开游标
DECLARE @cs_id varchar(50)
DECLARE @cs_name varchar(50)
FETCH NEXT FROM cursor_fruit into @cs_id,@cs_name --从游标变量中读取值
WHILE @@FETCH_STATUS=0 --判断FETCH语句是否执行成功
BEGIN
--相关操作
print @cs_id + '--------' + @cs_name
FETCH NEXT FROM cursor_fruit into @cs_id,@cs_name --读取游标变量中的数据
END
CLOSE cursor_fruit --关闭游标
DEALLOCATE cursor_fruit; --释放游标