we can use sqlserver 2005 for inserting data from XML into database tables

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.

Question Posted / santosh kakani

2 Answers
7448 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

Please Help Members By Posting Answers For Below Questions

Explain the top .net class that everything is derived from?

991

what user controls are and what server controls are and the differences between the two.

1980

Explain what is the difference between odbc and ado?

978

Explain me how does linq work?

1051

Explain what rare the types of jit and what is econo-jit?

964

How to create properties and methods using controls?

1058

What are asp.net authentication providers and iis security?

981

What is a .DLL and .EXE files called in .NET?

1033

What is SOAP? How you will do windows and forms authentication?

1092

What is your observations between vb.net and vc#.net?

1055

Please explain what is the difference between odbc and ado?

904

How do I spawn a thread?

917

Is there a way to suppress the finalize process inside the garbage collector forcibly in .net?

864

Is .net a language?

973

Why you want to leave your previous company.

2033