0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

create table #t1
(
id int
)

insert into #t1  select 1 union all select 2

create table #t2
(
id int
)

insert into #t2  select 2

Update #t1
set id=5
from #t2

fork query

edited jul 26 16

created jul 26 16 anonymous