declare @Mcode varchar(100)
set @mcode='123456789,'
SELECT replace(''''+@mcode+'''',',',''',''') AS CODE
结果是(‘123456789’,‘’)
declare @Mcode varchar(100)
set @mcode='123456789,'
SELECT replace(''''+@mcode+'''',',',''',''') AS CODE
结果是(‘123456789’,‘’)