Hate It. I believe there should be something like the VB "Option Explicit" which would explicitly disable any reserved words from being a DB object.
answered Oct 12, 2009 at 12:54 PM
Been using SQL Server since Sybase 4.2 and this drives me NUTS! It is NOT good practice to use brackets. What is good practice is NOT USING RESERVED WORDS as object names. Bracketing object names is a quick way to violate all sorts of bad practices, like using punctuation in your name. The genesis of brackets had to do with cross platform development and conversions. You can always add brackets to your code if you need to and SQL is smart enough to know the difference contextually 95% of the time anyway. When scripting, SSMS should identify reserved words that are being used as objects and bracket ONLY those. This would make it more obvious that you are using a reserved word. Please change this.
answered Dec 05, 2012 at 12:09 AM