var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Interesting ! Update query with alias ?
I have a below Oracle query :
UPDATE test1 a SET a.sno = 3
I need the equivalent SQL Server query for the above along with with alias name 'a' set for the table test1. Please advise.
UPDATE test1 AS a
SET a.sno = 3
I too tried the same, but I am getting the error 'Incorrect syntax near AS' in SQL Server 2000
How about this :
UPDATE a SET a.sno = 3 FROM test1 a
This is working fine...