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
Explain the top .net class that everything is derived from?
what user controls are and what server controls are and the differences between the two.
Explain what is the difference between odbc and ado?
Explain me how does linq work?
Explain what rare the types of jit and what is econo-jit?
How to create properties and methods using controls?
What are asp.net authentication providers and iis security?
What is a .DLL and .EXE files called in .NET?
What is SOAP? How you will do windows and forms authentication?
What is your observations between vb.net and vc#.net?
Please explain what is the difference between odbc and ado?
How do I spawn a thread?
Is there a way to suppress the finalize process inside the garbage collector forcibly in .net?
Is .net a language?
Why you want to leave your previous company.