可以帮忙做个例子么?初学,不太懂
追答没有具体的数据库不好说,我倒是有现成的例子,不知道你能不能看懂。
追问贴出来学习下,呵呵
追答前面定义游标,后面循环按照游标条件插入数据,表结构复杂些,也不是很难懂
declare @ClassID int
declare cur_class CURSOR for SELECT ClassID FROM #dept_class
open cur_class
fetch next from cur_class into @ClassID
while(@@FETCH_STATUS = 0)
begin
--取出每个节点的6个最新文档sp_Web_GetNewDoc 6, '2615'
insert into #doc
(
SuperClass,
DocID,
ClassID,
DocTitle,
DocApprover,
DocApproveDate,
DocViewedTimes,
DocType,
DocAddedBy,
DocAddedDate,
docDeletion,
DocLastViewer,
DocLastViewDate)
exec sp_Web_GetNewDoc @top,@ClassID
fetch next from cur_class into @ClassID
end
Close cur_class
DEALLOCATE cur_class