Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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.

Answers were Sorted based on User's Feedback



you have a requirement from client, he has an XML file and you need to insert the data into 5-6 ta..

Answer / 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

you have a requirement from client, he has an XML file and you need to insert the data into 5-6 ta..

Answer / suren

first check with the Scheme provided, if you have scheme
you can make use to serialise it.

The person will look for the technical feasibility and
solution providing strength and your way of explanation.
dont get stuck any where, shuld be very fluent using the
technical terms and sametime shuld be thoughtful in
understanding the requiement.

The business rounds goes in the same way, asking you to
explain your projects, architechture, DFD's protypes and
other things.

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More Dot Net General Interview Questions

What does .net stand for?

0 Answers  


What is view state?

6 Answers   TCS,


Difference between assembly manifest & metadata assembly manifest

4 Answers   Ksb,


How can I get at the win32 api from a .net program?

0 Answers  


What distributed process frameworks outside .NET do you know?

1 Answers  


What do you mean by web service?

0 Answers   Accenture,


Explain what is the difference between constants and read-only variables?

0 Answers  


How to implement CAS in .Net?

0 Answers   247Customer,


What is meant fulltrust?

1 Answers  


What is the difference between response.write & response.output.write?

0 Answers  


Difference b/w dataset.clone and dataset.copy ?

1 Answers   Protech,


questions on various scenarios on exception handling? like for example.... try { a; b; ...exception occurs here...what happens...will catch execute or will finally execute...will c execute c; } catch { a; b; c; } fianlly { a; b; }

1 Answers   Manhattan,


Categories