mtiDev
asked on
How do I send xml special characters (like &) to stored procedure
How do I send xml special characters (like &) to stored procedure....See the & below in T & A
Command: EXEC [dbo].[usp_wpCreateShipmentDocuments] @documents = <ShipmentDocuments><Item><SkShipmentNumber>15698</SkShipmentNumber><FormCwtCodeSKey>97</FormCwtCodeSKey><OriginPlantNumber>7019</OriginPlantNumber><GeneratorCustomerNumber>215555</GeneratorCustomerNumber><GeneratorPhone>708-499-1869</GeneratorPhone><GeneratorRegion>IL</GeneratorRegion><GeneratorMailName>T & A MOBIL SVC LTD</GeneratorMailName><GeneratorMailAddress1>10240 S PULASKI
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you have them in an XML datatype, it will already have & in it. Also, if you cast a string that has the value &, it will change it.
Try this
/peter
Open in new window