Showing posts with label How to update XML data in SQL Server using stored procedure?. Show all posts
Showing posts with label How to update XML data in SQL Server using stored procedure?. Show all posts

How to update XML data in SQL Server 2008 using stored procedure?

Step 1:Create a stored procedure that would take the input as XML data  & then break down the data to columns depending upon the XML tags formed: CREATE PROC spExtractDataFromXML (  @inputXML XML='' ) AS BEGIN SET NOCOUNT ON;   SELECT

Read More