sql server T-SQL while 循环 插入数据
向数据库表循环插入数据
--delete from [table]
DECLARE @step int
DECLARE @i int
select top(1) @i = Code from [table] order by Code desc
if (@i is NULL)
set @i=1
else
set @i = @i + 1
set @step=@i+50
WHILE @i<@step
BEGIN
insert [dbo].[tabl.
原创
2020-08-18 16:09:39 ·
572 阅读 ·
0 评论