SQLPROMPT Error formatting query hint IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX
BillSanscrainte
Posts: 4 New member
in SQL Prompt
Example:
SELECT * FROM sys.tables -- formatting works great
SELECT * FROM sys.tables OPTION (IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX) -- formatting fails with error "Error laying out sql. SQL Prompt encountered internal problems while processing this script. Exception: Object reference not set to an instance of an object."
SELECT * FROM sys.tables -- formatting works great
SELECT * FROM sys.tables OPTION (IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX) -- formatting fails with error "Error laying out sql. SQL Prompt encountered internal problems while processing this script. Exception: Object reference not set to an instance of an object."
Tagged:
Answers
https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-query?view=sql-server-2017