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
- 6667 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's the problem with .net generics?
Explain how does assembly versioning work?
What is PageIndex in DataGrid?What is the event used in the Datagrid for while moving from one page to another page in the Grid?write code for it
Tell us what do the following acronyms in .net stand for: il, cil, msil, cli and jit?
What is delegation in .net?
What are object pooling and connection pooling and difference?
Differences between dll and exe?
Why DLL files are needed. & how They are Created in DOTNET?
What is lazy initialization?
Dynamic Fonts
Tell us what is a variable of implicit type and what is its scope?
Explain what is heap and what is stack?
Dot Net Framework 
