Comments
2 comments
-
confirmed in Prompt v.9.2.1.5713. This is a valid query hint
https://docs.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-query?view=sql-server-2017
-
Thanks Steve!
Add comment
Please sign in to leave a comment.
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."