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
- 7550 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 a metadata in .net?
What are the properties of ADO.NET?
Can a try block have more than one catch block?
Show different types of collection in .NET?
Explain what is the difference between odbc and ado?
What is an anonymous method and how is it different from a lambda expression?
What is the purpose of enumerable class in .net?
What is the difference between server.transfer and response.redirect? Why?
How viewstate is being formed and how it is stored on client in .net?
How to create multiple inheritance in c#, with example?
What is the difference between odbc and ado?
Explain the purpose of Remoting in .NET?
What is difference between system.string and system.stringbuilder classes?
Explain the difference between .net 2000 and .net 2005(features)? Which one is better?
How to spawn a thread?
