数据恢复.txt

来自「C# 论坛 accesss数据库,支持SQL2000」· 文本 代码 · 共 47 行

-- ====版面数据转换From 1.0->2.0
-- ====
update forum_info set forum_info_parentId=forum_info_rootid 
-- ====
update forum_info set forum_info_rootId=forum_info_id where forum_info_rootid=0

-- ====
declare @forum_Info_id int
declare FastRead cursor for
select forum_Info_id from forum_Info 
open FastRead

WHILE (@@FETCH_STATUS = 0)

BEGIN 
 -- print @forum_Info_id 

    FETCH NEXT FROM FastRead into @forum_Info_id
 update forum_info set forum_info_times=
    (select max(forum_info_id) from forum_Info where forum_info_Rootid=@forum_Info_id) where Forum_info_id=@forum_Info_id
END

CLOSE FastRead

DEALLOCATE FastRead

-- ====
declare @forum_Info_id int,
 @forum_Info_RootId int

declare FastRead cursor for
select forum_Info_id,forum_Info_RootId from forum_Info 
open FastRead

WHILE (@@FETCH_STATUS = 0)

BEGIN 
 -- print @forum_Info_id 

    FETCH NEXT FROM FastRead into @forum_Info_id,@forum_Info_RootId
 update forum_info set forum_info_times=
    (select max(forum_info_Times) from forum_Info where forum_info_Rootid=@forum_Info_Rootid) where Forum_info_id=@forum_Info_id
END

CLOSE FastRead

DEALLOCATE FastRead