Nice question. For all those who use dynamic sqls and sometime stuck up in this scenario, here is the tip for you.

CREATE TABLE #A(COL1 INT)

INSERT INTO #A VALUES (1)

DECLARE @STR2 VARCHAR(100)

DECLARE @STR3 VARCHAR(100)

DECLARE @STR4 VARCHAR(100)

SET @STR1 = 'SELECT * FROM #A -- WHERE COL1 = 0'

SET @STR2 = 'SELECT * FROM #A --' + CHAR(13) + ' WHERE COL1 = 0'

SET @STR3 = 'SELECT * FROM #A /*' + CHAR(13) + ' WHERE COL1 = 0*/'

SET @STR4 = 'SELECT * FROM #A --/*' + CHAR(13) + ' WHERE COL1 = 0--*/'

PRINT @STR1

PRINT @STR2

PRINT @STR3

PRINT @STR4

Execute this, copy paste the result in query window. Check the result 🙂

SELECT * FROM #A -- WHERE COL1 = 0

SELECT * FROM #A --

WHERE COL1 = 0

SELECT * FROM #A /*

WHERE COL1 = 0*/

SELECT * FROM #A --/*

WHERE COL1 = 0--*/

Hope this helps. I use this metod frequently when in trouble..