Way of updating a table other than stored procedure and
hard coded query?

Answer Posted / raviraj

Try with transactions whose code is terse and comprehensive.
transactions offer the best alternative solutions for
updating the table content.You can either commit or
rollback the transcation by using T-sql update cpmmand in
the explicit transcation based on the where condition.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain difference betn dataset and recordset?

534


What are resource file and how do we generate resource file?

573


What is .net framework and what are the main components of it?

380


How can you apply a theme to your asp.net application?

539


What is preprocessor in .net and type, where it use?

662






What is an il?

566


What does a switch do?

543


Why is xap important?

604


How does session authentication work?

515


What is the difference between client-side and server-side validations in webpages?

565


Why do we use asp.net?

591


What are the differences between primary foreign and unique keys?

525


What are the uses of reflection?

583


What is the use of worker process in asp.net?

533


Differentiate between globalization and localization.

541