Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vmurali
Yak Posting Veteran
88 Posts |
 Posted - 2007-01-16 : 04:46:08
|
| Hi All, Please can anybody tell me how to parse an xml string in a stored procedure. I need to parse and do operations like insert,update and delete based on the flag send.RegardsMurali |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-16 : 04:49:45
|
| Why do you want to do it in SP? SQL is not very good at string manipulation. If you are using SQL 2005, you can use CLR for doing this. In SQL 2000, do parsing in the front-end using helper classes and pass parsed xml values to the SP.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
vmurali
Yak Posting Veteran
88 Posts |
Posted - 2007-01-16 : 05:00:21
|
| Thanks for ur reply. I will be given the xml string containing the data in xml format. I would have to insert into 2-3 tables with given xml string. I am using SQL 2005 as database.RegardsVenkatesh Murali |
|
|
|
|
|
|
Parsing XML in Store Procedure