m60a1 都说了是部分代码,这是从游标执行中截取的。我有这个需求,什么视图就不要考虑了。 liuyinbo0109 行吗?select * from exec proc是错误的
select @rowIndex = isnull(max(rowInex),0) from #TblCertificates INSERT INTO #TblCertificates execute usp_Certification_GetCompanyCertificationsByProjectIDCompanyID @ProjectID,@pCompanyID update #TblCertificates set CompanyID = @pCompanyID where rowIndex>@rowIndex
都说了是部分代码,这是从游标执行中截取的。我有这个需求,什么视图就不要考虑了。
liuyinbo0109 行吗?select * from exec proc是错误的
INSERT INTO #TblCertificates execute usp_Certification_GetCompanyCertificationsByProjectIDCompanyID @ProjectID,@pCompanyID
update #TblCertificates set CompanyID = @pCompanyID where rowIndex>@rowIndex