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.
- 2 Answers
- 7559 Views
- Deloitte, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is operator overloading in .net?
Why do we use msmq?
Explain me what are the deferred execution and the immediate execution in linq?
What method do you use to explicitly kill a users session? How?
Which method do you use to redirect the user to another page without performing a round trip to the client?
What is connection pooling and how do you make your application use it?
when web.config file is being called or referenced?tell me about the searialized procedure followed in page loading.
Explain the garbage collection process?
What are The Main Difference Between Client-server Based Applications and Web Based Applications
Resource Files: How to use the resource files, how to know which language to use?
Explain how to redirect tracing to a file?
What is a formatter?
Dot Net Framework 
