--12345678中的“1”替换为t，“2”替换为p
declare @str int
set @str=12345678
select    
 replace(replace(replace( replace(replace(replace(replace(replace(replace(replace(@str,1,'o'),2,'t'),3,'h'),4,'f'),5,'i'),6,'s'),7,'e')
,8,'g'),9,'n'),0,'z')

----------------------------------------------------------------------------------------------------------------
othfiseg

(1 行受影响)

------解决方案--------------------

探讨

SQL code
--12345678中的“1”替换为t，“2”替换为p
declare @str int
set @str=12345678
select    
 replace(replace(replace( replace(replace(replace(replace(replace(replace(replace(@str,1,'o'),2,'t'),3,'h'),4,'f……