DBA Myths: You can’t use an alias in an UPDATE statement.

(Kenneth Fisher) I’ve found a very common belief among users of T-SQL (both DBAs and Developers) is that you can’t use an alias with the UPDATE statement. As best I can tell the reason for this is because of a simple misunderstanding of the UPDATE command syntax.

Read More - Register for Free Membership