SQL游标及sp_executesql用法

最新推荐文章于 2022-10-18 09:00:33 发布

weixin_30952103

最新推荐文章于 2022-10-18 09:00:33 发布

阅读量217

点赞数

文章标签：数据库 java

原文链接：http://www.cnblogs.com/fery/archive/2010/08/24/1807653.html

版权

DECLARE @MyCur CURSOR
SET @MyCur = Cursor Local Scroll FOR SELECT TopicID,PostTable FROM TB_BBS_Topic WHERE BoardID = @SrcBoardID AND DATEDIFF(DAY,DateAndTime,GETDATE())> @Days
    OPEN @MyCur
    FETCH NEXT FROM @MyCur INTO @TopicID,@PostTable
    WHILE @@FETCH_STATUS = 0
     BEGIN
  SET @Sql = 'UPDATE '+ @PostTable + ' SET BoardID = '+ convert(varchar,@DestBoardID) + ' WHERE RootID = '+ convert(varchar,@TopicID)
  EXEC @Sql
        FETCH NEXT FROM @MyCur INTO @TopicID,@PostTable
     END
CLOSE @MyCur
Deallocate @MyCur

set @str_sql='SELECT @TotalRec=COUNT(AnnounceID) FROM '+ @PostTable +' WHERE ParentID <> 0 AND RootID ='+LTRIM(STR(@RootID))+' AND BoardID = '+LTRIM(STR(@BoardID))
exec sp_executesql @str_sql,N'@TotalRec int output',@TotalRec output

转载于:https://www.cnblogs.com/fery/archive/2010/08/24/1807653.html