SQL游标与日期比较-优快云博客

本文链接：https://blog.youkuaiyun.com/jasonvip_c/article/details/5346543

本文介绍了一段SQL脚本，该脚本使用游标来遍历StudyNotes表中的记录，并对比当前记录的日期与系统当前日期。如果记录的日期早于系统日期，则插入一条提醒记录到StudyNotes表中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

declare @data datetime , @userID int,@now varchar(20) ,@date varchar(20)
set @now =(select convert(varchar(20),year(getdate()))+convert(varchar(20) ,month(getdate()))+convert(varchar(20) ,day(getdate())))
DECLARE authors_cursor CURSOR FOR
SELECT StudyDate, UserID FROM StudyNotes as SN
WHERE StudyDate in (SELECT max(StudyDate) FROM StudyNotes WHERE UserID=SN.UserID )
OPEN authors_cursor
-- Perform the first fetch.
FETCH NEXT FROM authors_cursor into @data,@userID
-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
   -- This is executed as long as the previous fetch succeeds.
set @date=(select convert(varchar(20),year(@data))+convert(varchar(20) ,month(@data))+convert(varchar(20) ,day(@data)))
if(@date<@now)
     begin
    insert into StudyNotes (StudyName,StudyDate,UserID) values('你'+@date+'没记笔记哦!',getdate(),@userID)
    print @date+'这是date'+@now+'这是now'
     end
   FETCH NEXT FROM authors_cursor into @data, @userID