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
- 7473 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 |
Explain can 2 different applications use the same dll in gac at the same time?
Please explain what is the .net framework and how does it work?
What is the advantage of .net?
What is difference between .net core and .net standard?
What is Method Overriding? How to override a function in C#?
What is the native image generator?
If we want to write a Windows service that cannot be paused, only started and stopped. How to accomplish that?
How does cas works?
How can you turn-on and turn-off cas?
can we use private assembly in other project in dot net.
for the textbox if i want to allow only numbers.what ever the characters u enter it should not take.which event u used?
Is the COM architecture same as .Net architecture? What is the difference between them (if at all there is)?
Dot Net Framework 
