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