|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Transaction processingA couple of questions regarding transaction processing.
>From a windows application, does it make sense to use transaction management for SELECT statements?Does it make sense to use transaction management for a single UPDATE or INSERT statements? Thanks No
No No -- Show quote____________________________________ 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) ----------------------------------------------------------------------------------------------------------------------- "Dwight" <dtrumbo***@gmail.com> wrote in message news:1166722226.215731.156760@42g2000cwt.googlegroups.com... >A couple of questions regarding transaction processing. > >>From a windows application, does it make sense to use transaction > management for SELECT statements? > > Does it make sense to use transaction management for a single UPDATE or > INSERT statements? > > Thanks > Thanks Bill. I assumed that would be answer.
William (Bill) Vaughn wrote: Show quote > 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) > ----------------------------------------------------------------------------------------------------------------------- > > "Dwight" <dtrumbo***@gmail.com> wrote in message > news:1166722226.215731.156760@42g2000cwt.googlegroups.com... > >A couple of questions regarding transaction processing. > > > >>From a windows application, does it make sense to use transaction > > management for SELECT statements? > > > > Does it make sense to use transaction management for a single UPDATE or > > INSERT statements? > > > > Thanks > > 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 Show quote "Dwight" <dtrumbo***@gmail.com> wrote in message news:1166729046.954764.133580@a3g2000cwd.googlegroups.com... > Thanks Bill. I assumed that would be answer. > > > William (Bill) Vaughn wrote: >> 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) >> ----------------------------------------------------------------------------------------------------------------------- >> >> "Dwight" <dtrumbo***@gmail.com> wrote in message >> news:1166722226.215731.156760@42g2000cwt.googlegroups.com... >> >A couple of questions regarding transaction processing. >> > >> >>From a windows application, does it make sense to use transaction >> > management for SELECT statements? >> > >> > Does it make sense to use transaction management for a single UPDATE or >> > INSERT statements? >> > >> > Thanks >> > > 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 Show quote "William (Bill) Vaughn" <billvaRemoveT***@nwlink.com> escribió en el mensaje news:%23fxthhSJHHA.1064@TK2MSFTNGP04.phx.gbl... > 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) > ----------------------------------------------------------------------------------------------------------------------- > > "Dwight" <dtrumbo***@gmail.com> wrote in message > news:1166722226.215731.156760@42g2000cwt.googlegroups.com... >>A couple of questions regarding transaction processing. >> >>>From a windows application, does it make sense to use transaction >> management for SELECT statements? >> >> Does it make sense to use transaction management for a single UPDATE or >> INSERT statements? >> >> Thanks >> > >  |
|||||||||||||||||||||||
Other interesting topics