Posted By: kavos (Je to fajn, mit proc zit) on 'CZdatabases'
Title:     Re: update v SQL serveru
Date:      Sat Aug 30 15:30:26 2003

Co treba takhle:

create table table1 (id int, a int, b int, c int)
create table table2 (id int, aa int, bb int, cc int)

insert into table1 values(1, 11, 12, 13)
insert into table1 values(2, 21, 22, 23)
insert into table1 values(3, 31, 32, 33)

insert into table2 values(1, 111, 112, 113)

update table1 
set a = aa, b = bb, c = cc
from table2
where table1.id = table2.id

select * from table1

posledni select vraci:

1 111 112 113
2  21  22  23
3  31  32  33

kavos

> 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)
> 
> 
> Dik
> 
> 
> T.