本文介绍了一个使用T-SQL编写的脚本，该脚本通过循环方式批量插入数据到数据库表中。具体实现包括设置变量、构建动态SQL语句并执行。
drop proc alls
go
create proc alls
as
begin
declare @in int
declare @sql varchar(500)
set @in=0
while @in<100
begin
set @sql='insert into jiameng(comname,comadd,comtel,jiamengcontent) values('''+cast(@in as varchar(50))+''',''ss'',''qq'',''zz'')'
--set @sql='insert into jiameng(comname,comadd,comtel,jiamengcontent) values('''+cast(@in as varchar(50))+''','ss','qq','zz')'
exec(@sql)
set @in=@in+1
end
end
go
go
create proc alls
as
begin
declare @in int
declare @sql varchar(500)
set @in=0
while @in<100
begin
set @sql='insert into jiameng(comname,comadd,comtel,jiamengcontent) values('''+cast(@in as varchar(50))+''',''ss'',''qq'',''zz'')'
--set @sql='insert into jiameng(comname,comadd,comtel,jiamengcontent) values('''+cast(@in as varchar(50))+''','ss','qq','zz')'
exec(@sql)
set @in=@in+1
end
end
go
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
