创建一个存储过程:
CREATE PROCEDURE SP_REMIND_DATES
AS
BEGIN
...
END
GO
---------------------------------------------------------------------------------------------------------------------------
使用游标遍历数据:
DECLARE YOUBIAO CURSOR FOR SELECT WORK_PLAN_UUID FROM QLC_WORK_PLAN
OPEN YOUBIAO /* 打开游标 */
DECLARE @WP_UUID NVARCHAR(60)
FETCH NEXT FROM YOUBIAO INTO @WP_UUID /* 读取第1行数据*/
WHILE @@FETCH_STATUS =