Posted By: jerryiii (Vsude dobre, v CR nejhur) on 'CZdatabases'
Title:     Re: update v SQL serveru
Date:      Fri Jul 18 16:45:46 2003

> v podstate potrebuju prepsat update ktery se da v orcle napsat takto >
> update table1  set (aa,bb) = (select XX,YY from table2 where table1.id = 
> table2.id )

Budto si nadefinuj kurzor anebo dve promenny, vyber do nich a pak s nima 
updatuj. Chces konkretni priklad?

> diky 
> 
> TEx.

          Jerry III

Enough said ...
http://jerryiii.home.sprynet.com/mica/index.htm

Search the boards