Click here to Skip to main content
11,920,156 members (57,491 online)
Rate this:
Please Sign up or sign in to vote.
See more: C#2.0 C# MySQL
We are migrating Stored Procedure from MS SQL Server to mysql.
We ran into problems with sp_xml_preparedocument.

If anyone have suggestion, please do not hesitate
Posted 31-Dec-12 0:16am
Edited 31-Dec-12 11:10am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

MySQL has the following functions to work on Xml[^]. try looking at them.
ExtractValue()  Extracts a value from an XML string using XPath notation
UpdateXML() Return replaced XML fragment

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 455
1 phil.o 170
2 CPallini 150
4 F-ES Sitecore 130
0 OriginalGriff 6,778
1 KrunalRohit 4,495
2 Sergey Alexandrovich Kryukov 3,153
3 George Jonsson 2,810
4 Suvendu Shekhar Giri 2,181

Advertise | Privacy | Mobile
Web01 | 2.8.151120.1 | Last Updated 1 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100