SQL SERVER 批量插入记录

最新推荐文章于 2021-03-22 09:11:20 发布

XuPlato

最新推荐文章于 2021-03-22 09:11:20 发布

阅读量403

点赞数

文章标签： SQL 数据库 sql server

本文链接：https://blog.csdn.net/github_30397645/article/details/49175451

版权

--create function insertData(@count as int,@tsn as bigint,@id as int)
--as 
--begin
SET IDENTITY_INSERT Table_Name OFF
declare @tsn  bigint --这儿用int会溢出
declare @count int
declare @id int

set @count= 0
set @tsn = 678833010119069
set @id= 24982

while(@count<10)
begin
    set @tsn=@tsn+1
	set @id=@id+1
	set @count=@count+1
	
Insert into Table_Name (Col-Name,....)
values (
	'0',
	'',	
	@tsn,
	@tsn,
	'5',
	@tsn,
	'123456',	
	@tsn,
	'1',	
	'1',	
	'',
	'',
	'',
	'0',	
	'0',
	'0',
	'',
	'0',
	'0',
	'',
	'',
	'2015/7/4',
	'8',	
	'0',
	'2016/7/4',
	'1190',
	'0',
	'0',
	'0',
	'0',
	'0',
	'',
	'0',
	'0',
	'0',
	'0',
	'1',
	'0',
	'2015/10/15 13:18',
	'2015/7/4 13:31',
	'053255678033',
	'',
	'',
	'120',
	'0',
	'1',
	'',
	'a4bf5d7e-ce3d-47db-b899-eb2d665c0578',
	'1',
	'1',	
	'0',
	'',
	'0',
	'1',
	'0'
)
end