sql在循环中定义表变量的问题

declare @count int
set @count=4;
while(@count>0)
begin
DECLARE @STAKEHOLDERLIST TABLE (USERID UNIQUEIDENTIFIER,ID INT);
INSERT INTO @STAKEHOLDERLIST (USERID)
     EXEC [SP_GETCONSULTUSERLISTBYTASKID] 22,'83F297BF-9B03-4C3C-B949-DE849018A725'
select * from @STAKEHOLDERLIST
set @count=@count-1
end

 

declare @count int
DECLARE @STAKEHOLDERLIST TABLE (USERID UNIQUEIDENTIFIER,ID INT);
set @count=4;
while(@count>0)
begin
delete  @STAKEHOLDERLIST
INSERT INTO @STAKEHOLDERLIST (USERID)
     EXEC [SP_GETCONSULTUSERLISTBYTASKID] 22,'83F297BF-9B03-4C3C-B949-DE849018A725'
select * from @STAKEHOLDERLIST
set @count=@count-1
end

转载于:https://www.cnblogs.com/shikyoh/archive/2012/02/06/2340404.html