【禁回此贴】数据转换FAQ--不断增加中

DECLARE @fid int
DECLARE tables_cursor CURSOR FOR SELECT [fid] FROM [dnt_forums]
OPEN tables_cursor
FETCH NEXT FROM tables_cursor INTO @fid
WHILE @@FETCH_STATUS = 0
BEGIN

DECLARE @tcount INT
DECLARE @pcount INT
SELECT @tcount = (SELECT COUNT(*) FROM dnt_topics WHERE fid=@fid)
SELECT @pcount = (SELECT COUNT(*) FROM [dnt_posts1] WHERE fid=@fid) --在此只对一个分表进行操作 ，如果有多个分表请自己修改代码

UPDATE [dnt_forums] SET [topics]=@tcount ,[posts]=@pcount WHERE fid=@fid
FETCH NEXT FROM tables_cursor INTO @fid
END
CLOSE tables_cursor
DEALLOCATE tables_cursor