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
7474 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

What are the types of jit?

1006

Is .net core installed?

986

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

1992

What is .net environment?

1038

What exactly is being serialized when you perform serialization in .net?

984

How do you create threading in.net?

955

What is the difference between response.redirect & server.transfer?

1068

What is "common language runtime" (clr) in .net?

1031

What is different between webusercontrol and in webcustomcontrol?

935

Explain the main components in .net?

1010

What is the difference between .net 2000 and .net 2005(features)? Which one is better?

926

What are the properties of ADO.NET?

1089

Explain me difference between public and static modifiers?

1015

How do you generate a strong name?

1062

Explain the features that are common to all .Net languages.

1105