Posted By: BigFoot (go!go!go!) on 'CZdatabases'
Title:     Re: update v SQL serveru
Date:      Thu Jul 17 16:10:24 2003

> HI,
> nevite jak updateovat vic sloupcu najednou ?
> vim jak v oracel ...
> 
> update xxx set (a,b,c)=(select a,b,c from BBB where xxx.id = bbb.id)

Existuje klicove slovo REPLACE. Nepamatuju si presne usage, ani nevim, je-li 
to standard bo jenom rozsireni tech pidi-databazi, se kterymi jsem prisel do 
styku. Je to vlastne INSERT, ale kdyz narazi na nejakou tu "constraint 
violation" (unique bo primary key), provede misto INSERTu nahrazeni. Jenomze 
ten REPLACE se AFAIR tyka celeho recordu, ne jenom explicitne definovanych 
fields; takze nevim, jestli ti to nebude k ho_nu ... 

> T.

BigFoot, aka Yaroukh; yaroukh@email.cz
"Budiz svetlo", rekl Booh - a bylo svetlo ...
"Budiz k nicemu", rekl Booh - and here I am !
8}__ __ _