Interested to Buy Any Domain ? << Click Here >> for more details...
you have a requirement from client, he has an XML file and
you need to insert the data into 5-6 tables in database.
explain me the procedure.
- 2 Answers
- 7635 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / santosh kakani
we can use sqlserver 2005 for inserting data from XML into
database tables
example
insert into <Table_Name> select * from openxml(@doc,
'/Root/customer',;)
with (Custid varchar(10)'/Root/Customer/@Custid', cname
varchar(30)'/Root/Customer/@Cname')
then Exec sp_Xml_RemoveDocument @ doc
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is Event - Delegate? clear syntax for writing a event delegate
Tell about your technical profile ?
Does .net supports destructors concept?
What is the difference between user control an custom control? Advantages/disadvantages?
Why did they call it .net?
what is the keyword used for self reference?
What are the different.net tools which you used in projects?
What is iis? Have you used it?
What is a garbage collector?
What is a formatter in .net?
How is threading done in .net?
Different between .net & j2ee ?
Explain the difference between constants and read-only variables?
What are the security policy levels in .Net
Give a brief introduction on side-by-side execution. Can two applications, one using private assembly and the other using the shared assembly be stated as side-by-side executables?
