Re: Is there ever a reason to have a transaction around a select...



It depends on your requirements but usually there is no need for (explicit) transaction.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"David Thielen" <thielen@xxxxxxxxxxxxx> wrote in message news:88DB2D9D-01F6-403F-93AF-1CABC892247B@xxxxxxxxxxxxxxxx
1) that will always return 0 or 1 rows?

2) that will retun N rows?

In each case where the results will be displayed to the user and so there
can be changes that occur to the DB after the select completes.

--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com

Cubicle Wars - http://www.windwardreports.com/film.htm



.



Relevant Pages

  • Re: Joining two datatables with no primary key
    ... INETA Country Leader for Slovenia] ... RightHand .NET consulting & development www.rthand.com ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DBnull in dataTable.Columns.Add()
    ... INETA Country Leader for Slovenia] ... RightHand .NET consulting & development www.rthand.com ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Unable to sort Dataview
    ... INETA Country Leader for Slovenia] ... RightHand .NET consulting & developmentwww.rthand.com ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Computed Columns
    ... INETA Country Leader for Slovenia] ... RightHand .NET consulting & development www.rthand.com ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Unable to sort Dataview
    ... INETA Country Leader for Slovenia] ... RightHand .NET consulting & development www.rthand.com ...
    (microsoft.public.dotnet.framework.adonet)