Pretty simple question – I have an attribute that I would like to have double quotes in. How do I escape them? I've tried
And I've made the @xml variable both xml type and varchar(max) for all of them.
declare @xml xml --(or varchar(max) tried both) set @xml = '<transaction><item value="hi "mom" lol" ItemId="106" ItemType="2" instanceId="215923801" dataSetId="1" /></transaction>' declare @xh int exec sp_xml_preparedocument @xh OUTPUT, @xml insert into @commits --I declare the table, just removed it for brevity select x.* from openxml(@xh,'/transaction/item') WITH ( dataItemId int, dataItemType int, instanceId int, dataSetId int, value varchar(max) ) x