How do I escape double quotes in attributes in an XML String in T-SQL?
tSql escapes a double quote with another double quote. So if you wanted it to be part of your sql string literal you would do this:
declare @xml xml set @xml = "<transaction><item value=""hi"" /></transaction>"If you want to include a quote inside a value in the xml itself, you use an entity, which would look like this:
declare @xml xmlset @xml = "<transaction><item value=""hi "mom" lol"" /></transaction>"