Re: common UPDATE syntax for SqlServer and Oracle
From: Hugo Kornelis <hugo_at_pe_NO_rFact.in_SPAM_fo>
Date: Fri, 26 Nov 2004 14:19:51 +0100
Message-ID: <p9beq0dt70nlimp6ggmpf48be7tv781t1q_at_4ax.com>
Date: Fri, 26 Nov 2004 14:19:51 +0100
Message-ID: <p9beq0dt70nlimp6ggmpf48be7tv781t1q_at_4ax.com>
On Fri, 26 Nov 2004 07:31:59 -0500, Serge Rielau wrote:
>I believe the ANSI standard allows:
Umm, yes. I believe you're right. Unfortunately, that part of ANSI sql is
not available in SQL Server 2000 (don't know about Oracle, thoug), so it
won't help Jan.
Best, Hugo
>UPDATE Table1
> SET (city_id, another_column) = (SELECT T2.id, other column FROM etc
>WHERE ...)
>WHERE EXISTS(...)
Hi Serge,
-- (Remove _NO_ and _SPAM_ to get my e-mail address)Received on Fri Nov 26 2004 - 14:19:51 CET