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.
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 )