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
- 6683 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 the advantage of packaging over xcopy in .net?
What are nullable types in .NET
Tell about your technical profile ?
Explain what is reflection in microsoft .net context?
Is there any thread in our .net programs?
What is the benefit of .net core?
What is data type and how many types of data types are in .NET ?
Compare client server application with n-tier application
What is meant by managed and unmanaged code?
Explain how to spawn a thread?
Explain what is the difference between odbc and ado?
How do you view the methods and members of a dll?
How to produce an assembly?
What is the difference between asp.net & vb.net and explain architecture?
What's singlecall activation mode used for in .net?
