declare @i int 
declare @name varchar(10)
set @i=0;
set @name='str'
while  @i <10
    begin
        set @name=''
        set @name='str'+ltrim(@i)
        print @name
        set @i=@i+1
    end

/*
str0
str1
str2
str3
str4
str5
str6
str7
str8
str9
*/

declare @i int 
declare @name varchar(10)
set @i=0;
set @name='str'
while  @i <10
    begin
        set @name=''
        set @name='str='+ltrim(@i)
        print @name
        set @i=@i+1
    end

/*
str=0
str=1
str=2
str=3
str=4
str=5
str=6
str=7
str=8
str=9
*/

--这样？？
declare @i int  
declare @name varchar(3) 
declare @sql varchar(1000)
set @i=0; 
set @name='str' 
set @sql=''
while  @i<10 
begin 
      set @sql=@sql+' declare '+@name+ltrim(@i)+' int; set '+@name+ltrim(@i)+'='+ltrim(@i)+';'  
      set @i=@i+1 
end 
print @sql