34,575
社区成员
发帖
与我相关
我的任务
分享
DECLARE
@info_title nvarchar(50),
@info_content nvarchar(50),
@info_uid nvarchar(50),
@infoAll int
begin
SELECT @infoAll=COUNT(*) FROM Z_info WHERE is_xh=1
if @infoAll>0
begin
DECLARE My_Cursor CURSOR --定义游标
FOR (select info_title,info_content,info_uid from Z_info WHERE is_xh=1) --查出需要的集合放到游标中
OPEN My_Cursor;
FETCH NEXT FROM My_Cursor INTO @info_title,@info_content,@info_uid
WHILE @@FETCH_STATUS = 0
BEGIN
insert into Z_info(info_title,info_content,info_uid,info_dateTime)values(@info_title,@info_content,@info_uid,GETDATE())
FETCH NEXT FROM My_Cursor INTO @info_title,@info_content,@info_uid
END
CLOSE My_Cursor
DEALLOCATE My_Cursor
end
end