how to handle with single quote in ms sql server
2011-12-29 17:27 wildboar 阅读(187) 评论(0) 编辑 收藏 举报declare @lablesList varchar(max) = 'test1&test2'
set @lablesList = Replace(@lablesList, '&', ''',''')
set @lablesList = ''''+ @lablesList +''''
select @lablesList