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
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 'Common Type System' (CTS) in .NET?
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; }
i m fresher,hav SQL knowledge but in my ofc. i hav to work on dotnet. so plz tell me how to learn it,? from where to stat? i hav C prog. knowledge, ASP.net
How is .net core cross platform?
What is a DLL?
What is RunTime Polymorphism?
5 Answers Deloitte, eClerx, Horizon, Intel, Pragna Technologies,
What is deferred execution vs. Immediate execution in linq?
Which dll is required to translate xml to sql in internet information server (iis)?
What?s SingleCall activation mode used for?
What are the types of assemblies in .net?
Explain what is the difference between a class and an object, and how do these terms relate to each other?
What are the features of dot net?