declare @i int
set @i=1
while @i<=120
begin
exec('insert into kh_gr_jbxx (xm,xb) values('+'测试'+@i+','+'男'+')')
set @i=@i+1
end
相让插入的值为测试1、测试2,但是同步噢不了
set @i=1
while @i<=120
begin
exec('insert into kh_gr_jbxx (xm,xb) values('+'测试'+@i+','+'男'+')')
set @i=@i+1
end
相让插入的值为测试1、测试2,但是同步噢不了
修改为
'测试'+convert(@i as varchar)
set @i=1
while @i<=120
begin
exec('insert into kh_gr_jbxx (xm,xb) values('+'测试'+cast(@i as varchar)+','+'男'+')')
set @i=@i+1
end
declare @sql varchar(500)
set @i=1
while @i<=120
begin
set @sql='insert into kh_gr_jbxx (xm,xb) values(''测试'+cast(@i as varchar)+''','''男)'
exec(@sql)
set @i=@i+1
end
declare @sql varchar(500)
set @i=1
while @i<=120
begin
set @sql='insert into kh_gr_jbxx (xm,xb) values(''测试'+cast(@i as varchar)+''',''男'')'
exec(@sql)
set @i=@i+1
end
set @i=1
while @i<=120
begin
set @sql='insert into kh_gr_jbxx (xm,xb) values(''测试'+rtrim(@i)+''','''男''')'
exec(@sql)
set @i=@i+1
end
go
'测试'+convert(@i as varchar)
------------------------------------------------要改为'测试'+cast(@i as varchar)
declare @str varchar(8000)
set @i=1
while @i<=120
begin
set @str='insert into kh_gr_jbxx(xm,xb) values('+'''测试'+cast(@i as varchar)+''',''男'')'
exec(@str)
set @i=@i+1
end
declare @i int
declare @sql nvarchar(500)
declare @xm varchar(10),@xb varchar(2)
set @i=1
set @xb='男'
while @i<=120
begin
set @xm=cast(@i as varchar)
set @xm='测试'+@xm
set @sql=N'insert into #kh (xm,xb) values(@xm,@xb)'
exec sp_executesql @sql,N'@xm varchar(10),@xb varchar(2)',@xm,@xb
set @i=@i+1
end
select * from #kh
drop table #kh