<div>
aneeshattingal<br />
Should I do that on the vb side? &nbsp;Or with some kind of an xml.mofify in SQL
</div>


aneeshattingal
Should I do that on the vb side?  Or with some kind of an xml.mofify in SQL

<div>
<div class="content wysiwyg-content">
I have a stored procedure that accepts and processes an XML paramater being passed in.<br />
<br />
The xml is then processed with<br />
EXEC sp_xml_preparedocument @handle OUTPUT, @XmlDoc_Local<br />
<br />
However...<br />
The XML occassionally comes in with apostrophes (Bing's) and my procedure errors out.<br />
<br />
Is there a way to modify the inbound XML to strip or handle the apostrophes?
</div>
</div>


I have a stored procedure that accepts and processes an XML paramater being passed in.

The xml is then processed with
EXEC sp_xml_preparedocument @handle OUTPUT, @XmlDoc_Local

However...
The XML occassionally comes in with apostrophes (Bing's) and my procedure errors out.

Is there a way to modify the inbound XML to strip or handle the apostrophes?

Handle apostrophesn inbound xml

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.