Transact-SQL Commands

select *

In 12.5.4, the expanding of the column-list is enhanced in a way that identifiers (table-names, column-names, and so on) are checked if they comply with the rules for identifiers.

For all identifiers used in the text expanding a select *, brackets are added when the identifier does not comply with the rules for identifiers.

You must add brackets around identifiers to make sure Adaptive Server can use the SQL-text while performing an upgrade to a more recent release.