Christopher Kings-Lynne wrote:
>> I think because START TRANSACTION is SQL standard? However, I thought
>> BEGIN WORK was SQL standard, and we don't support READ ONLY there
>> either --- hmmm.
>
>
> BEGIN is no part of the SQL standard. The only way to begin a
> transaction under the SQL standar
On Sun, 2003-10-26 at 19:22, Gaetano Mendola wrote:
> Hi all,
> why START TRANSACTION READ ONLY is allowed
> and not BEGIN READ ONLY ?
As Chris KL points out, it's not required by the standard (since BEGIN
isn't part of the standard to begin with). I suppose we could add it,
but it seems a little
I think because START TRANSACTION is SQL standard? However, I thought
BEGIN WORK was SQL standard, and we don't support READ ONLY there
either --- hmmm.
BEGIN is no part of the SQL standard. The only way to begin a
transaction under the SQL standard is START TRANSACTION.
Chris
-
Gaetano Mendola wrote:
> Hi all,
> why START TRANSACTION READ ONLY is allowed
> and not BEGIN READ ONLY ?
I think because START TRANSACTION is SQL standard? However, I thought
BEGIN WORK was SQL standard, and we don't support READ ONLY there
either --- hmmm.
--
Bruce Momjian
