Transaction processing

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

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" <dtrumbower@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:
> 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" <dtrumbower@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

"Dwight" <dtrumbower@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" <dtrumbower@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



"William (Bill) Vaughn" <billvaRemoveThis@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" <dtrumbower@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
>>
>
>