本文共 196 字，大约阅读时间需要 1 分钟。
select IDENTITY(INT,1,1) AS 序号,* into #a1 from spkfkdjok
select 'XJPZ'+right('00000'+cast(xuhao as nvarchar(10)),5),* from spkfkdjok
转载地址：http://cujta.baihongyu.com/