select top 100 'X'+ CONVERT(varchar(100),CONVERT(int, replace(@n,'X',''))+t.n) from
(select n= ROW_NUMBER() over(order by tlntcode) from PKTAEXPRM0) t
转载于:https://www.cnblogs.com/xuelan/p/4228892.html
select top 100 'X'+ CONVERT(varchar(100),CONVERT(int, replace(@n,'X',''))+t.n) from
(select n= ROW_NUMBER() over(order by tlntcode) from PKTAEXPRM0) t
转载于:https://www.cnblogs.com/xuelan/p/4228892.html