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.
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
Explain how garbage collection works?
What is the use of UML in .Net
What is Flyout Design Pattern in .NET?
When a Static Constructor called in .NET?
what is the keyword used for self reference?
Explain what is a manifest in .net?
Explain how com+ related to the dna architecture?
Difference between abstract class and interface in .net?
Explain me how does linq work?
What are the deferred execution and the immediate execution in linq?
Elements of CAS
Explain me what is the difference between an abstract class and an interface?
What is the difference between user control an custom control? Advantages/disadvantages?
Explain what is the difference between response.redirect & server.transfer?
How to view a .NET assembly?