how to handle with single quote in ms sql server

declare @lablesList varchar(max) = 'test1&test2'
set @lablesList = Replace(@lablesList, '&', ''',''')
set @lablesList = ''''+  @lablesList +''''
select @lablesList

原文地址:https://www.cnblogs.com/wildboar/p/2306456.html