select IDENTITY(INT,1,1) AS 序号,* into #a1 from spkfkdjok
select 'XJPZ'+right('00000'+cast(xuhao as nvarchar(10)),5),* from spkfkdjok