Re: all about transaction

From: Steve Kass (skass_at_drew.edu)
Date: 12/14/04 

Date: Tue, 14 Dec 2004 08:58:16 -0500

Thanks for picking up the thread and answering Deepson's questions while
I slept!

SK

Hugo Kornelis wrote:

>On Tue, 14 Dec 2004 02:09:03 -0800, Deepson Thomas wrote:
>
>
>
>>Hi Hugo thanks once again ... i got the words chained and unchained from
>>sybase sqlserver ref...
>>
>>
>(snip)
>
>Hi Deepson,
>
>Well, Sybase is not SQL Server, though they do have the same ancestry.
>
>Based on your explanation of chained and unchaiend transactions in Sybase,
>I think that the only thing that is roughly comparable in SQL Server is
>the SET IMPLICIT_TRANSACTIONS [ON | OFF] command.
>
>With this setting on, most SQL statements (see Books Online for the full
>list) will automatically begin a transaction if one isn't active. This
>transaction will remain open until explicitly committed or rolled back or
>until an error condition occurs that implicitly rolls back the open
>transaction.
>
>With the implicit transaction setting off, transactions will only be
>started when an explicit BEGIN TRANSACTION is executed. Statements that
>are not enclosed in a transaction will still be executed as ATOMIC
>operations (as if the statement itself was enclosed between BEGIN TRAN and
>COMMIT TRAN).
>
>Best, Hugo
>
>

Relevant Pages

  • Re: all about transaction
    ... Well, Sybase is not SQL Server, though they do have the same ancestry. ... list) will automatically begin a transaction if one isn't active. ... COMMIT TRAN). ...
    (microsoft.public.sqlserver.programming)
  • Re: all about transaction
    ... Thank u very much Hugo... ... and what if i start a transaction and edited a record and at the ... both of us commit the transactions whatever the data i edited will get ... > uncommitted transaction isolation level, you'll have to be aware that you ...
    (microsoft.public.sqlserver.programming)
  • Re: Transaction when client shutdown
    ... Hugo Kornelis wrote: ... >> I check your scenario, and I find that you right. ... > there is indeed no automati commit or rollback of open transactions. ... > The transaction remains open and any locks are held until the ...
    (microsoft.public.sqlserver.programming)
  • Re: all about transaction
    ... Thank u Hugo. ... > Well, Sybase is not SQL Server, though they do have the same ancestry. ... > list) will automatically begin a transaction if one isn't active. ... > COMMIT TRAN). ...
    (microsoft.public.sqlserver.programming)
  • Re: Multiple insert in one pass
    ... Hi Yaheya, ... COMMIT TRANSACTION ... Best, Hugo ... (Remove _NO_ and _SPAM_ to get my e-mail address) ...
    (microsoft.public.sqlserver.programming)