Transaction processing

  • Thread starter Thread starter Dwight
  • Start date Start date
D

Dwight

A couple of questions regarding transaction processing.
From a windows application, does it make sense to use transaction
Click to expand...
management for SELECT statements?

Does it make sense to use transaction management for a single UPDATE or
INSERT statements?

Thanks
 
No
No
No

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
 
Thanks Bill. I assumed that would be answer.

No
No
No

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
Click to expand...
 
you can just use try catches to catch some of the errors that can come up
coz' of data in tables, or any other reason..

Regards,
Sugandh
 
I think the first question is not always as simple as "NO". In some
circumstances, may be usefull to use a transaction under snapshot isolation
level.

Regards:

Jesús López
 
Back
Top