Re: common UPDATE syntax for SqlServer and Oracle

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

-- 

(Remove _NO_ and _SPAM_ to get my e-mail address)