Qualify Ojects in SQL (Add square brackets)
When formatting SQL, add an option to force all possible columns/objects/whatever to be qualified with square brackets. So:
CREATE TABLE #qqqqq (aaaaa INT,bbbbb INT,ccccc VARCHAR(5));
Becomes: CREATE TABLE [#qqqqq] ([aaaaa] INT,[bbbbb] INT,[ccccc] VARCHAR(5));
Or: CREATE TABLE [#qqqqq] ([aaaaa] [INT],[bbbbb] [INT],[ccccc] [VARCHAR](5));
This is included in SQL Prompt 6.5 which you can download from http://www.red-gate.com/products/sql-development/sql-prompt/
Paul Shearing commented
Yes I agree. I much prefer the look of code with square brackets around database, schema, table and field names, even where such are not required (i.e. white-space in the names). I think it significantly aids readability. Such a feature would save me typing time and ensure consistency in my SQL coding.
It would also be helpful to have an option to add square brackets only for reserved word or a list of names that can be managed by the user.