HI Friends
i am using sqlserver2005 .
I have column in my table with xml DataType .and while i am inserting data into it ,if '&' is there in data it is giving xml parser error as "XML parsing: line 1, character 15, illegal name character"
i have idea that xml parsing & is represented as 'amp' , but i cannot do that
my requirement is to insert the data as it is.
ex:of my insert statement is insert into dbo.XMLTest values ('~ABC; XXX ABC& !ABC');
is there any alternative way to insert "~ABC; XXX ABC& !ABC" in to xml column
Thanks
|