SqlServerKudos - Bad habits to kick : using table aliases like (a, b, c) or (t1, t2, t3)

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

1
kudos

Kudos

Bad habits to kick : using table aliases like (a, b, c) or (t1, t2, t3)

published 845 days, 23 hours, 13 minutes ago posted by

sa 850 days, 20 hours, 26 minutes ago

Bad habits to kick : using table aliases like (a, b, c) or (t1, t2, t3)

In my last post in this series, I talked about using old-style JOINs. Today I'd like to touch on using aliases. No, I don't mean fake passports and a life of crime, I mean using an alias as shorthand for referencing a table or view in a query.

Some code I once had to clean up on an inherited system looked a lot like this:SELECT * FROM Orders a INNER JOIN OrderDetails b ON

category: News | clicked: 3 | | source: sqlblog.com | show counter code

tags: Best Practices, habits, table aliases

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

SqlServerKudos