sqlserver 2005 数据库游标的应用

--declare @ParentID varchar(50)
--set @ParentID='6' --当前父ID
--257
declare @OldId int
set @OldId='321' --原分类ID

--取旧分类ID

--DECLARE @TheNodeID INT
--BEGIN
-- SELECT @TheOldID=ClassID FROM dbo.Cl_Article WHERE ClassID=@NewType
--END

--IF @TheNodeID>0

declare @id int,@title varchar(50),@content varchar(5000)
declare @addtime datetime,@ClassID int,@HtmlUrl varchar(200),@ImageUrl varchar(100),@laiyuan varchar(100)
declare?? c_tmp?? cursor?? for?? select
?ArticleID,ClassID,Title,CopyFrom,UpdateTime,[Content],DefaultPicUrl,HtmlFileUrl
FROM triphr8.dbo.Cl_Article WHERE ClassID=@OldId
? open?? c_tmp??
fetch? next from c_tmp into @id,@ClassID,@title,@laiyuan,@addtime,@content,@HtmlUrl,@ImageUrl
while?? (@@fetch_status<>-1)??
? begin??
?--???? .....具体操作....?
--@ParentID='2'
--SET @ParentPath= Cast(@ParentID as varchar) + '|'+ Cast(@ClassID as varchar)
--@ClassName=
--@ClassDir=
--@Depth='2'
--Cast(@last as nvarchar) 类型转换

insert into yidihr.dbo.qy_Article (
id,title,keyword,[content],addname,addtime,hits,classId,Passed,HtmlUrl,ImageUrl,laiyuan
)
values
(@id,'master','0','1',@ImageUrl,@laiyuan)

fetch next from c_tmp into @id,@ImageUrl
? end??
? close?? c_tmp??
? deallocate?? c_tmp

//////?? 第二个

新闻分类导入
declare @ParentID varchar(50)
set @ParentID='2' --当前父ID

declare @OldId int
set @OldId='101' --原频道ID

--101 - 2?? 新闻 news
--102 - 6 酒店培训 train
--103 - 4 - 酒店管理 guanli
--104 - 7?? 旅游之窗 travel
--105 - 8? 餐饮资讯 eat
--116 - 3? 求职指南 qzzn
--120 - 5 -酒店知识 HotelKnowledgez

--取旧分类ID
--DECLARE @TheNodeID INT
--BEGIN
-- SELECT @TheOldID=ClassID FROM dbo.Cl_Class WHERE ChannelID=@NewType
--END

--IF @TheNodeID>0

declare?? @ClassID?? int,@ClassDir varchar(50),@ClassName varchar(50),@ParentPath varchar(50)
declare?? c_tmp?? cursor?? for?? select ClassID,ClassName,ClassDir FROM triphr8.dbo.Cl_Class WHERE ChannelID=@OldId
? open?? c_tmp??
fetch?? next?? from?? c_tmp?? into?? @ClassID,@ClassName,@ClassDir
while?? (@@fetch_status<>-1)??
? begin??
?--???? .....具体操作....?
--@ParentID='2'
SET @ParentPath= Cast(@ParentID as varchar) + '|'+ Cast(@ClassID as varchar)
--@ClassName=
--@ClassDir=
--@Depth='2'
--Cast(@last as nvarchar) 类型转换

insert into yidihr.dbo.ArticleClass (Column_ID,Column_Name,Parent_ID,Column_Path,Column_Depth,Column_Order,Column_Intro,Column_Keywords,Column_Dir)
values
(@ClassID,@ParentID,@ParentPath,'2','10',@ClassDir)

fetch?? next?? from?? c_tmp?? into?? @ClassID,@ClassDir? end?? ? close?? c_tmp?? ? deallocate?? c_tmp

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!