正文
SqlServer 批量添加记录
小程序:扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序
【扫一扫了解最新限行尾号】
复制小程序
declare @i int
set @i=1
while(@i<=10)
beginINSERT INTO [dbo].[Settlements]
([ID]
,[Count]
,[SettlementDate])
VALUES
( newid()
,cast( floor(rand()*100) as int) --随机int
,DATEADD(DAY,1,(select top 1 [SettlementDate] from [Settlements] order by [SettlementDate] desc )) --获取表中最大的日期然后加1
)set @i=@i+1
end