Alternative to single quote terminators for strings in SQL Server

Vote count: 0

I know in MySQL and a couple of other databases, you can use double quotes and single quotes, but it seems like double quotes are reserved for column names in SQL Server. In PHP, you can use <<<EOTs.

I'm writing a ton of queries that only have single quotes in the string values and it is becoming a nuisance to have to escape every single single-quote with an extra single quote. Is there an alternative to single quote terminators for strings?

asked 1 min ago

Ralph Wiggum
2,186

This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at http://ift.tt/jcXqJW.

Alternative to single quote terminators for strings in SQL Server