UPDATE (Level 4)
|SQL Server 6.x||SQL Server 2000|
|In Microsoft® SQL Server™ version 6.0, the following UPDATE statement, using two different table aliases for the same base table, was allowed:
|Syntax no longer supported. Use the alias, rather than the table name, after the UPDATE keyword. The UPDATE statement would be rewritten to:
Expect differences in behavior as compared to SQL Server version 6.0.
|This UPDATE statement with table and alias references worked.
|The alias specified after the UPDATE keyword must match the alias specified following the SET keyword. Without this change, the compatibility level setting must be changed to 65 for this UPDATE statement to function as it did in version 6.x.
Here is the same UPDATE statement rewritten:
Expect differences in behavior as compared to SQL Server version 6.x when using different table references following the UPDATE keyword of the UPDATE statement and the SET keyword of the UPDATE statement.