Sql Server 2005 宝典 Sql Server 2005 Bible

[Table Name]

If the name of a database object, such as a table or column name, conflicts with a SQL keyword,you can let SQL know that it’s the name of an object by placing it inside square brackets

Although it’s considered poor practice to include spaces within the names of database objects, some database developers don’t follow this guideline. If this is the case, square brackets are required when specifying the database object.

在两种情况下，需要对数据库对象（表名，列名）加上方括号：对象名和数据库关键字冲突；对象名中有空格