Why is SQL Prompt formatter adding [...] around collation name?
For example:
ALTER TABLE [dbo].[SomeTable]
Formatter would try to do this:
ALTER TABLE [dbo].[SomeTable]
which results in an error.
I couldn't find anything in options to exclude collation names from the rule to add square brackets around all identifiers.
It's not a big issue with a small queries with just one or too COLLATE's but it pretty annoying when it's in a long query and COLLATE is used in many places (as part of JOIN, WHERE ...).
For example:
Formatter would try to do this:
I couldn't find anything in options to exclude collation names from the rule to add square brackets around all identifiers.
It's not a big issue with a small queries with just one or too COLLATE's but it pretty annoying when it's in a long query and COLLATE is used in many places (as part of JOIN, WHERE ...).