27 Search results

For the term "alias".

Bad Habits and Best Practices

An index of over a decade's worth of posts and videos involving bad habits and best practices in SQL Server.

T-SQL Tuesday #21 : Crap Code

Yes, Adam is right: we've all written crap code (the topic of this month's T-SQL Tuesday Wednesday. Usually we have an excuse: tight deadline, short shelf life of the code, or didn't know any...

Deprecate UPDATE FROM? Not if I can help it!

Fellow MVP Hugo Kornelis (blog) has suggested that the proprietary UPDATE FROM and DELETE FROM syntax, which has worked for several SQL Server versions, should be deprecated in favor of MERGE. Here is the...