The role of square brackets in SQL Server

I am also very helpless ah ...

You have this skill 、、、 build a table to try?

Obviously not.

Check the table structure again.

Front small predecessors a little pit ...

SELELCT [group] from Tablle Yes

should be the [square brackets] as the character of it ...

Front of the small predecessors at the same time feedback, find out the column name unexpectedly is group ...

Verify that it's really ...

Why is this?

Check ...

The reasons are:

The square brackets represent an object name (view, stored procedure, table, etc.), column name, and can be distinguished by [square brackets] when the reserved word is used as the object name or as a column name.

The role of square brackets in SQL Server