var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Update one table with value from other table
I have two tables named onsite and operations. I want to update one table with the value from other table. I can use something like this in MySQL 4.0.
update onsite o, operations p set o.username = p.username where o.userid = p.userid;
Can any one tell me how to do this in SQL Server.
Thnks in advance
update o set o.username=p.username from onsite o,operations p where o.userid = p.userid