Viewing 2 posts - 1 through 2 (of 2 total)
Yep and the returned string includes single quotes so no need to include additional quotes before tbe plus sign
July 13, 2014 at 5:35 am
#1728980
you can use quotename to make the input string a valid SQL Server delimited identifier.
DECLARE @quotedvar nvarchar(100)
DECLARE @sql nvarchar(1000)
SET @quotedvar = 'O''Neil'
SET @sql = 'PRINT...
July 13, 2014 at 4:35 am
#1728976