Anti-nuisance lawsuit warning: The purpose of these notes is to remind me, Zoegond, of stuff or to help me work stuff out. They may contain mistakes.

Quick

  • ($a, $b....) = unpack("A2A7...", $packed)
  • push( array, list )

Wednesday, January 25, 2012

SQL Server transactions

Three modes:

Autocommit = each statement is effectively its own transaction.
Implicit = transaction starts with the first DML statement and continues until you issue COMMIT or ROLLBACK. Another transaction starts at the next DML statement.
Explicit = you delimit transactions with BEGIN TRAN/COMMIT TRAN.

All connections start in autocommit mode.
Implicit mode is entered and left with SET IMPLICIT_TRANSACTIONS.
Explicit transactions are delimited by their BEGIN/COMMIT. When the transaction finishes, autocommit mode resumes.

Followers

Blog Archive