sql 流水号的递增

 

 

declare @i int
set @i=340
while @i<415
begin
    set @i=@i+1
    insert into LJWK007H
    select '2024','28','9110','3PTSD6210000000','3','2024-07-09 11:17:07.510','402056001',@i,NULL,0.0000,200.0000,0.0000,    0.0000,    0.0000,    1.0000,    '自动生成',    'A1207091',    '2024-07-09 11:17:07.510',    NULL,    NULL,    'A1207091',    0,    NULL,    NULL,    0.0000,    200.0000,    200.0000,    'A'
end