Posts
Sort by recent activity
Line Break / Bug
Hi Regate Team,I did not find any solution to ensure the line break will look like thisbefore[code]SELECT shipperid, YEAR(shippeddate) AS shipyear, COUNT(*) AS numordersFROM Sales.OrdersGROUP...
ALTER TABLE HISTORY_RETENTION_PERIOD / Bug
Hi!SQL Prompt will cause an error formatting this statementALTER TABLE dbo.testSET (SYSTEM_VERSIONING = ON (HISTORY_RETENTION_PERIOD = 1 DAY));GO
Thanks for fixing!Torsten
HISTORY_RETENTION_PERIOD / Bug
Hi redgate Team,the following statement will cause an error from SQL Prompt and HISTORY_RETENTION_PERIOD will not suggested.CREATE TABLE test( col1 int NOT NULL PRIMARY KEY , col2 varchar(100) ...
SET TEMPORAL_HISTORY_RETENTION ON
Hi Redgate Team,It seems that there is not SQL Prompt support for
-- Enbable retention policy for a temporal tablesALTER DATABASE AdventureWorks2017 SET TEMPORAL_HISTORY_RETENTION ON;GOTEMPORAL_HI...
Case When Then
Hi Redgate Team,the following code is formatted like[code]SELECT sya.id , sya.name AS alerter_name , sya.event_source , sya.event_category_id , sya.event_id , sya.message_id , sya.severity AS...
SQL Prompt Bug
Hi Redgate Team,the following statement is valid but SQL Prompt raise an error./******************************************************************************* in-memory OLTP - Preparation******...
Check Constraint
Hi!Can you please ensure that if a check constraint exceed to number of character (word wrap) it will break before the Check word.Current
ALTER TABLE mdm.Code_MappingADD CONSTRAINT CHK_Code_Mapping...
Alignment BUG
Hi!The following statement is formatted like this:[code]-- Start the session io_readsIF NOT EXISTS ( SELECT * FROM sys.dm_xe_sessions WHERE name = N'io...
Alignment
Hi Redgate Team,The following code is formatted like this
[code]SELECT *FROM dbo.test_statisticsWHERE col1 = 101OPTION (QUERYTRACEON 9481 -- Redirects the output to SSMS , ...
Spaces
Hi !The following code is formatted with a lot of spaces betweenALTER TABLE mdm.Synchronization_StatusADD CONSTRAINT PKCL_Synchronization_Status_synchronization_timestamp PRIMARY KEY ( sy...