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
What is the base class of Button control in .NET?
Is .net capable of supporting multi-thread?
Explain the process of compilation in .NET?
Explain the difference between task and thread in .net?
explain the states of a window service application?
How to implement CAS in .Net?
What is garbage collection in .net? Explain the garbage collection process?
What is WSDL? Explain its architecture?
What is static constructor, when it will be fired?
What is data type and how many types of data types are in .NET ?
What is the concept of inheritance and how it works in .net?
What is the difference between user control an custom control? Advantages/disadvantages?
What are the types of assemblies in .net?
Differences between datagrid, datalist and repeater in .net?
Sql Queries: A Table will be given Omiting Duplicate rows and adding a new column