sql 流水號的遞增

侬侬发發表於2024-07-19
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

相關文章