Dynamic SQL STUFF statement syntax

2

Try this. It's dynamic sql , so for this you should add some additional '

DECLARE 
    @SQL AS VARCHAR(MAX)
    ,@schema_Table_name VARCHAR(MAX) = 'dbo.contact'

SET @SQL=STUFF((SELECT ', ' + QUOTENAME([name])
+ ' = replace(replace(replace(LTRIM(RTRIM(' + QUOTENAME([name]) + ')), '' '','' '' + char(7)), char(7) + '' '',''''),char(7),'''')' 
FROM
    sys.columns 
WHERE 
    object_id=object_id(@schema_Table_name)
    AND collation_name IS NOT NULL
FOR XML PATH('')),1,1,'')
PRINT @SQL

SET @SQL = 'UPDATE ' + @schema_Table_name + ' SET' + @SQL
PRINT @SQL
1 Like