How to Open A XML Document in Sql Query

Posted by Sabarimahesh under Sql Server on 3/16/2012 | Points: 10 | Views : 2568 | Status : [Member] | Replies : 8
By Using OpenXml ..

I KNow This ..

But Please Say Separately With insert/update/select

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M



Responses

Posted by: Sksamantaray on: 3/16/2012 [Member] Silver | Points: 25

Up
0
Down
Hi Sabarimahesh,
For your reference
http://msdn.microsoft.com/en-us/library/ms186918.aspx
http://www.techrepublic.com/article/read-an-xml-file-from-sql-server/5796532

Thanks,
Sanjay

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sabarimahesh on: 3/16/2012 [Member] Bronze | Points: 25

Up
0
Down

Refer in this
http://asp.net-tutorials.com/state/viewstate/

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Hmanjarawala on: 3/16/2012 [Member] Bronze | Points: 25

Up
0
Down
Hi try this:

http://www.techrepublic.com/article/read-an-xml-file-from-sql-server/5796532
http://sqlanywhere.blogspot.in/2008/04/openxml-rocks.html

Himanshu Manjarawala
Sr. Software Engineer@AutomationAnywhere
http://fieredotnet.wordpress.com/

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patel28rajendra on: 3/17/2012 [Member] Starter | Points: 25

Up
0
Down
Hi
refer this also

http://blog.sqlauthority.com/2009/02/12/sql-server-simple-example-of-creating-xml-file-using-t-sql/

R D Patel

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sabarimahesh on: 3/19/2012 [Member] Bronze | Points: 25

Up
0
Down
Hi Patel28rajendra

Ya Fine Dude...

I worked Yesterday

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sabarimahesh on: 3/19/2012 [Member] Bronze | Points: 25

Up
0
Down
Hmanjarawala

Thanks

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Patel28rajendra on: 3/19/2012 [Member] Starter | Points: 25

Up
0
Down
Hi

gud to listen you find it

Thanks

R D Patel

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sabarimahesh on: 3/19/2012 [Member] Bronze | Points: 25

Up
0
Down
Patel28rajendra
Thank You

Life is a Race
Thanks & Regards
By
Sabari Mahesh P M

Sabarimahesh, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response