Sunday, November 06, 2011

MS SQL Server update based on two tables

update r
set pass = x.pass
from InternetUser r inner join InternetUser x
on r.id = x.id
where r.pass = 'kjfkd9wjj2390eds9d';

No comments: