sql中加序号

select IDENTITY(INT,1,1) AS 序号,* into #a1 from spkfkdjok

select 'XJPZ'+right('00000'+cast(xuhao as nvarchar(10)),5),* from spkfkdjok