sql server dts: SQL 2000 UPDATE statements vs SQL 7 -- sql server dts

SQL 2000 UPDATE statements vs SQL 7

jjone99 NO[at]SPAM hotmail.com
7/13/2003 12:23:51 PM

sql server dts: Hello,

We've migrated from SQL 7 to SQL 2000 and it seems that some of the
existing UPDATE statements aren't working correctly.

-- current -- (SQL 7)
update company_items_quarterly
set company_id = c.company_id
from company_items_quarterly cq, company c
where cq.ticker = c.ticker
---------------

-- Modified -- (SQL 2000)
update cq
set cq.company_id = c.company_id
from company_items_quarterly cq, company c
where cq.ticker = c.ticker
---------------

will any of these statements work on SQL 7 and SQL 2000? It seems to
me that some procedures that use the UPDATE w/ JOIN work, and some
don't.

Re: SQL 2000 UPDATE statements vs SQL 7

John Bell
7/13/2003 10:48:10 PM

Hi

This is actually mentioned in Books online as a level 4 compatibility issue
between 6.5 and higher releases.

I have found occassions where SQL7 does not complain regarding syntax, when
you would not expect the statement to work.

John

[quoted text, click to view]