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
- 7125 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 typical about a windows process in regards to memory allocation in .net?
Please explain what is the difference between a class and an object?
Explain what is the reason of occurring overflow-underflow arithmetic exception error, it shows error message when we run our program by adding control?
Conceptually, what is the difference between early-binding and late-binding?
What is assemblies in .net?
Sql Queries: A Table will be given Omiting Duplicate rows and adding a new column
How to create multiple inheritance in c#, with example?
How can you instantiate a tuple?
What is file extension of Webservices in .Net?
Why inheritance is important?
What is operator overloading in .net?
What tags do you need to add within the asp:datagrid tags to bind columns manually.
If I am writing in a language like vb or c++, what are the procedures to be followed to support .net?
What is the native image generator?
Do you know what is garbage collector?
