I honestly don't know if they're part of ANSI SQL, but I'd be willing to bet they are in at least one of the more recent versions. Now, whether your favorite database *supports* them, that's another story....
I wouldn't bet on Access getting them any time soon. ;-) Ted Neward Author, Presenter, Consultant Java, .NET, XML services http://blogs.tedneward.com > -----Original Message----- > From: Discussion of advanced .NET topics. [mailto:ADVANCED- > [EMAIL PROTECTED] On Behalf Of J. Merrill > Sent: Thursday, January 05, 2006 5:41 AM > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM > Subject: Re: [ADVANCED-DOTNET] Nested transactions > > Are there framework methods for using savepoints, or do you have to > execute a SQL statement to use them? > > I just learned that savepoints aren't SQL-Server-only (I had thought that > they were) -- they seem to be available in Oracle (at least since 10.2). > They aren't part of "standard SQL", are they? > > At 07:20 AM 1/5/2006, Ted Neward wrote > >Savepoints are often used to provide the same basic kind of behavior that > >nested transactions are asked to provide, a la your example scenario. I'd > go > >with the savepoint: > > > >Start trans > >Begin loop > > Do work > > Create savepoint > >End loop > >Commit trans or rollback > > > >Note that you can also rollback to a savepoint if necessary/desired. > Check > >the SQL Server docs for how many open savepoints you can have. > > > >Bear in mind, too, that you're holding locks throughout the window of the > >transaction, so savepoints don't release any contention issues here. > > > >Ted Neward > >Author, Presenter, Consultant > >Java, .NET, XML services > >http://blogs.tedneward.com > > > J. Merrill / Analytical Software Corp > > =================================== > This list is hosted by DevelopMentor. http://www.develop.com > > View archives and manage your subscription(s) at > http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
