How do you embed double quotes in a literal when using SQL Server?
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.