Is there an equivalent of PostgreSQL's Dollar-quoted String Constants, on SQL Server?
I would like to enter HTML string literals that would potentially contain single or double quotes in them.
UPDATE table_name SET column_name = $$ Here's a string that contains "double quotes". $$ WHERE condition = true
The reason I'm asking this is because I would like to update some rather big HTML "web parts" that are stored in the database (yuck!). Because at work we use that kind of CMS (which I won't give you the name). So I don't want to have to escape my single quotes every time. That's why I'm asking about that kind of feature. If I understand correctly,
QUOTENAME would still require me to double my single quotes.