Posts
Sort by recent activity
remove unnecessary square brackets
Hi Redgate Team,I guess that the feature add/remove square brackets / remove unnecessary square brackets are not working as intended.I expect that the square brackets for reserved words will not be...
Format issue
Hi Redgate Team,SQL Prompt will format the following statement-- Apply the classifier function ALTER RESOURCE GOVERNOR WITH (CLASSIFIER_FUNCTION = dbo.fn_time_classifier);like this There is n...
Formatting issue Table Type
Hi Redgate Team,SQL Prompt formats the Data Type like thisCREATE TYPE dbo.test AS TABLE( col1 int NOT NULL , col2 int NOT NULL , col3 int NOT NULL , PRIMARY KEY NONCLUSTERED ( col1 ...
Grouping Sets
Hi Redgate Team,Wrap lines longe than does not work for GROUPING SETSIt would be good to see a well formatted Grouping Sets as well - thanks for fixing!SELECT wait_type , resource_waiter_type , r...
CREATE DATABASE SCOPED CREDENTIAL / failed to format
Hi Redgate Team,the following statement will cause an error when trying to format.CREATE DATABASE SCOPED CREDENTIAL [my-storage-credential] WITH IDENTITY = 'SHARED ACCESS SIGNATURE', SECRET = '?sv=...
THROW
Hi Redgate Team!SQL Prompt will format the following statement BEGIN TRY RAISERROR('test', 16, 1);END TRYBEGIN CATCH SELECT 1 THROWEND CATCH;like thisBEGIN TRY
RAISERROR('test', 16, 1);
END TRY
BE...
format error
Hi Redgate Team,SQL Prompt will report an error when trying to format the following statementCREATE NONCLUSTERED COLUMNSTORE INDEX [NCLCSI_product_price_latest_ID_product_price_latest] ON [products...
Smaller formatting issue
Hi Redgate Team,It would be nice to see the UNIQUE CLUSTERED aligned to the other columns,.Thanks
CREATE TYPE products.product_price AS TABLE( sap_location char(5) NOT NULL , sap_product char(9) ...
No support for filtered nonclustered columnstore index
Hi Redgate team,it seems that there is no intellisense for the WHERE in a filtered columnstore index.CREATE NONCLUSTERED COLUMNSTORE INDEX NCI_SalesOrderHeader_RevisionNumber_FLTRON Sales.SalesOrde...
Bug / DATA_COMPRESSION
Hi Redgate Team,the following valid code cause SQL Prompt to fail.DROP TABLE IF EXISTS test;GO-- Create a tableCREATE TABLE test( col1 int NOT NULL , col2 int NOT NULL , col3 CHAR(100) NOT NULL ...