Remove/replace String Literals
When you code a SELECT statement as:
SELECT EffDt AS 'EffectiveDate'
SQL PROMPT advises that string literals as column aliases have been deprecated.
Have an option to convert string literals, similar to Remove Square Brackets. In this case, Convert Column Aliases would either remove the apostrophes, where appropriate, or add square brackets if required (e.g. the alias contained special characters, a space or reserved word).
3
votes
Doug
shared this idea
-
T
commented
In addition. have the Column Aliases display in another color. Although deprecated using literals made them stand out in red making it easy to see if you missed placing a comma between fields.