Chris Hurlbut - Monday, February 12, 2018 12:10 PM
DECLARE @v_SQL Nvarchar(MAX) -- Should be Nvarchar
DECLARE @QT Nchar(1) = NCHAR(39) -- declare the quote character as a variable rather than using the function later.
SET @v_SQL = CONCAT( -- Using CONCAT can make it easier to write and read, especially for casts
N'DELETE FROM dbo.Some_Table', @crlf,
N'WHERE Person = ' , @QT, N'JONES', @QT,
N';'
)