Re: column update order

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 20 Nov 2006 20:03:10 -0800
Message-ID: <1164081790.296669.285220@f16g2000cwb.googlegroups.com>

Charles Hooper wrote:
> An individual UPDATE, INSERT, or DELETE will be consistent as of the
> time the DDL begins, as will a SELECT. Additionally, within a
> transaction, all SELECTs, UPDATEs, INSERTs, and DELETEs will be
> consistent as of the start of the transaction.
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.

Should state DML (manipulation) not DDL (definition), in case that causes any confusion. DDL causes an implicit COMMIT.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Mon Nov 20 2006 - 22:03:10 CST