Hi,
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.
Thanks,
SamI'd use:UPDATE test1 AS a
SET a.sno = 3-PatP|||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...
No comments:
Post a Comment