Re: Q: Does any ANSI-SQL standard address multi-column updates ?
From: --CELKO-- <71062.1056_at_compuserve.com>
Date: 12 Feb 2002 13:05:04 -0800
Message-ID: <c0d87ec0.0202121305.df95b27_at_posting.google.com>
Date: 12 Feb 2002 13:05:04 -0800
Message-ID: <c0d87ec0.0202121305.df95b27_at_posting.google.com>
>> Does anyone have information or a site where I can learn more about
which ANSI-SQL standard or level formalizes/blesses/requires
multi-column updates using multi-column lookup? <<
The SQL-99 standard has syntax for a row constructor in the UPDATE
statement; you can get a book on SQL-99 from Amazon.com or
Fatbrain.com for details. Working from memory, it is something like:
UPDATE Target
SET ROW (a,b,c,..)
WHERE ...;
Received on Tue Feb 12 2002 - 22:05:04 CET