SQLServer system table 'master..sysprocesses' cannot be parsed about sql-formatter HOT 3 CLOSED

Fixed in 15.1.0 release.

from sql-formatter.

Thanks for reporting.

Can you point me to any resources that document this .. syntax in SQLServer?

I know of similar syntax in BigQuery, but there one can only use it inside quoted table names like `project..dataset....table` where the repeated . is simply treated the same as single .. Does the SQLServer also simply allow repeated .. instead of just ., or does the multi-dot syntax have some special meaning?

from sql-formatter.

Thanks for reporting.

Can you point me to any resources that document this .. syntax in SQLServer?

I know of similar syntax in BigQuery, but there one can only use it inside quoted table names like `project..dataset....table` where the repeated . is simply treated the same as single .. Does the SQLServer also simply allow repeated .. instead of just ., or does the multi-dot syntax have some special meaning?

master..sysprocesses is a shorthand for the [database_name].[schema_name].[object_name] format. I apologize, as I am also not clear on where this syntax is located in the official documentation, but it is indeed legal in SQL Server.

from sql-formatter.