[Quote=引用 2 楼 的回复:]
insert into BOMCA(CA001,CA002,CA003)
select '5555',left('00000'+rtrim(row_number() over(order by getdate())),5),MI001 from BOMMI
[/Quote]
--insert into BOMCA(CA001,CA002,CA003)
select '5555'CA001,SUBSTRING('0000',1,5-LEN(CONVERT(VARCHAR(5),ROW_NUMBER()OVER(ORDER BY GETDATE()))))+CONVERT(VARCHAR(5),ROW_NUMBER()OVER(ORDER BY GETDATE())) CA002,MI001 CA003
from BOMMI