declare @id int
declare @str nvarchar(5)
declare @ids varchar(2)
set @id=1
set @str=N'模块'
while @id <=10
begin
set @ids=cast(@id as varchar(2))
insert into testmodule(modulename) values(@str+@ids)
set @id=@id+1
end
declare @str nvarchar(5)
declare @ids varchar(2)
set @id=1
set @str=N'模块'
while @id <=10
begin
set @ids=cast(@id as varchar(2))
insert into testmodule(modulename) values(@str+@ids)
set @id=@id+1
end
declare @str nvarchar(5)
declare @s nvarchar(10)
set @id=1
set @str=N'模块' while @id <=10
begin
set @s=@str+cast(@id as nvarchar)insert into testmodule(modulename) values(@str+@id)
set @id=@id+1
end