Showing results for 
Search instead for 
Do you mean 

How to Embed Double Quotes in a Literal for SQL Server.

by Anonymous on ‎02-15-2016 09:57 AM - edited on ‎04-06-2016 01:16 PM by Moderator (2,944 Views)

Question

How do you embed double quotes in a literal when using SQL Server?

Answer

If you enclose the whole string in double quotes instead of single ticks, you have to double double quote double quotes. For example:

 

update isistypes set sfviewname = "Tim's value=""some value""" where id = 1;

 

Would yield a value of:  Tim's value="some value"  to the column.

Contributors