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
When we use windows api in .net is it managed or unmanaged code?
what is dotnet architecture? can anyone explain that.
Explain what is reflection in microsoft .net context?
What is the use of activex control in .net?
Explain me what is .net web service?
Please explain what is the difference between a class and an object?
What is static constructor, when it will be fired? And what is its use?
What is the use com component in .net?
What is the new three features of COM+ services, which are not there in COM (MTS)
Tell us why do we use the “using” statement?
Explain the use of activex control in .net?
How is meant by dll in .net?
What is difference between system.string and system.stringbuilder classes?
what is the default security setting in .net?
What is the difference between .net and laravel?