微信扫一扫
sql中加序号 更新：HHH 时间：2023-1-7
select IDENTITY(INT,1,1) AS 序号,* into #a1 from spkfkdjok
select 'XJPZ'+right('00000'+cast(xuhao as nvarchar(10)),5),* from spkfkdjok