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
- 7141 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 .net technology?
What is Complex Class in .NET?
What is loosely coupled solution in.net?
What is the difference between constants and read-only variables?
i had attended to infosys interview on 17th april 2010...on .net..3+ experience for Technology Analyst .. to my knowledge i did well in technical and hr whether i loose the interview or still processing is taking place..am confused please. what accuatly would be happend?
what will do to avoid prior case?
How to create multiple inheritance in c#, with example?
Please explain what is reflection and what is it for?
Explain how garbage collection works?
What is meant by managed and unmanaged code?
Explain what is the difference between a class and an object?
How to load a user control dynamically in runtime?
Explain the difference between constants and read-only variables?
What are Attributes in .NET?
What are .net applications?
