Re: common UPDATE syntax for SqlServer and Oracle
From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sat, 27 Nov 2004 19:29:05 -0800
Message-ID: <1101612450.212876_at_yasure>
>
>
> Hi Serge,
>
> 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
Date: Sat, 27 Nov 2004 19:29:05 -0800
Message-ID: <1101612450.212876_at_yasure>
Hugo Kornelis wrote:
> On Fri, 26 Nov 2004 07:31:59 -0500, Serge Rielau wrote:
>
>
>>I believe the ANSI standard allows: >>UPDATE Table1 >> SET (city_id, another_column) = (SELECT T2.id, other column FROM etc >>WHERE ...) >>WHERE EXISTS(...)
>
>
> Hi Serge,
>
> 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
It does exist in Oracle. Too bad about SQL Server though.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sun Nov 28 2004 - 04:29:05 CET