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 |
Elements of CAS
Which Security Algorithm used to encrypt the data? a) DES b)RC2 c)Triple DES d)All the above
how do you retrieve the customized properties of a .NET application from XML .config file? Can you automate this process?
What is namespaces in .net?
What security measures exist for .NET Remoting in System.Runtime.Remoting?
How do you view the methods and members of a dll?
Do you know what's the difference between .net and laravel?
Define code access security (cas)?
What are the new features of Framework 1.1 ?
Explain the features that are common to all .Net languages.
How can we convert XML data into DataBase table IN .Net?
How is .net able to support a lot of languages?