请问在查询分析器中：表名：userinfo_list user_id：test1-999
user_uint:TO 怎么一次插进test1-999所有的用户
------解决方案--------------------------------------------------------
declare @i int --变义变量@i set @i = 1 --初始化@i为1 while @i < 100 begin ------------------ insert into userinfo_list ([user_id],[user_name],user_unit) values( 'test ' + cast(@i as varchar(3)), 'test ' + cast(@i as varchar(3)), 'T0 ') set @i = @i + 1 end --------------------
------解决方案--------------------------------------------------------
或者这样：
select top 999 identity(int,1,1) as id
into #
from master..sysobjects x, master..sysobjects y
insert into userinfo_list(user_Id, user_unit)
select 'test ' + convert(varchar(3), id), 'To '
from #
drop table #
------解决方案--------------------------------------------------------
declare @i int --变义变量@i
set @i = 1 --初始化@i为1
while @i < 1000
begin ------------------
insert into userinfo_list ([user_id],user_unit) values( 'test ' + cast(@i as varchar(3)), 'T0 ')
set @i = @i + 1
end --------------------