SQL Server UPDATE statement to note

Aliases cannot be used for tables in update statements in SQL Server

Eg:update Table A set a.column= "" where ...

This is not true in SQL Server (it can be in Oracle), and you can't use aliases for tables.

This is because the UPDATE statement we've been writing is abbreviated, and it's actually the right thing to do:

Update T set t.column= ' from table t where ...

Reference: http://blog.csdn.net/zyzlywq/article/details/6753648

Reference : http://www.cnblogs.com/KevinYang/archive/2010/07/09/1774063.html

SQL Server UPDATE statement to note