begin declare @strSql varchar(100) declare @counts int set @counts=0
while @counts<3 begin set @counts=@counts+1 set @strsql='insert into test values(data'+convert(varchar,@counts)+')' print(@strsql) execute(@strsql) end end
begin declare @strSql varchar(100) declare @counts int set @counts=0
while @counts<3 begin set @counts=@counts+1 set @strsql='insert into test values(''data'+convert(varchar,@counts)+''')' print(@strsql) execute(@strsql) end end
begin declare @strSql varchar(100) declare @counts int set @counts=0
while @counts<3 begin set @counts=@counts+1 set @strSql='insert into test values(''data'+convert(varchar,@counts)+''')' print(@strSql) --execute(@strsql) end end
declare @counts int
set @counts=0
while @counts<3
begin
set @counts=@counts+1
set @strsql='insert into test values(''data'+convert(varchar,@counts)+''')'
print(@strsql)
execute(@strsql)
end
end
declare @counts int
set @counts=0
while @counts<3
begin
set @counts=@counts+1
set @strSql='insert into test values(''data'+convert(varchar,@counts)+''')'
print(@strSql)
--execute(@strsql)
end
end