use esales
declare @myid int
select @myid=2
declare @nCorpID int
declare @nCorpIDDest int
declare @nAction int
declare @nNum int
declare cursorProcNames cursor for
SELECT nCorpID,nCorpIDDest,nAction,nNum
FROM tblOrder
WHERE (nCorpID = @myid) OR
(nCorpIDDest = @myid)
open cursorProcNames
while 1 = 1
begin
fetch next from cursorProcNames into @nCorpID,@nCorpIDDest,@nAction,@nNum
if @@fetch_status <> 0
break
print @nAction
end
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。