SQL Lint / Code Analysis Tools

Transact-SQL
5

Sorry, no I was meaning adding an alias to the Table and prefixing each column with that alias:

SELECT A.Col1,
       B.Col1,
       ...
FROM TableA AS A
     JOIN TableB AS B

This will, then, raise an error

SELECT A.Col1    -- Comma missing
       B.Col1,
       ...
FROM TableA AS A
     JOIN TableB AS B

I read a blog article the other day which experimented with whether this improved performance, or not. Can't remember the answer - Doh! - but there appeared to be a significant difference between the two