表变量 循环表 存储过程

  declare @count int
    declare @OrderID nvarchar(50)
 declare  @VariationOrderTable table(IndexID int identity(1,1),ID nvarchar(50))
 declare @index int
 insert into @VariationOrderTable

 
 set @index=1;
DECLARE @subject NVARCHAR(360);  
 while(@index<=@count)
 begin

  set @index=@index+1;
 end

原文地址:https://www.cnblogs.com/wanyuan8/p/2176430.html