Posts
Sort by recent activity
Additional space after SELECT
Hi Redgate Team,
I have my own customized style and since the last update I am now getting an additional space after the SELECT.
I tried to get rid of it without success.
Can you please give me a h...
Semicolon
Hi Redgate Team
The following code will fails due to a missing semicolon which should be inserted automatically
BEGIN TRAN -- missing semicolon here...
WITH CTE_A
AS
(select 1)
ROLLBACK TRAN
Would ...
DBCC WITH TABLERESULTS;
Hi Redgate Team,
the following command will become invalid by formatting the code by adding AS.
DBCC PAGE(TransactionLog,2,0,3) WITH TABLERESULTS;
GO
--after formatting
DBCC PAGE(TransactionLog,2,0...
parentheses
Hi Redgate Team,
most of the settings to control the parentheses does not have any effect.
So I guess it is a bug.
It would be nice if you can fix it because I like the idea to control the parenthe...
Insert empty line between join clauses
Hi Redgate Team,
The following statement will cause a formatting issue:
SELECT 1
FROM
sys.dm_exec_requests AS r
INNER JOIN
sys.dm_exec_sessions AS se
ON
r.session_id = se.session_id
FULL OUTER JOIN...
BEGIN CATCH and IF AND
Hi Redgate Team
The following code
BEGIN CATCH@TRANCOUNT > 0
AND XACT_STATE() <> 0
BEGIN
ROLLBACK TRAN;
END;
THROW;
END
will be formatted like this:
BEGIN CATCH@TRANCOUNT > 0
AND XACT_STATE() <> 0
...
please delete
Hi Redgate Team,
The code
BEGIN CATCH@TRANCOUNT > 0 AND XACT_STATE() <> 0
ROLLBACK TRAN;
THROW;
END CATCH;
GO
will be formatted like this:
BEGIN CATCH@TRANCOUNT > 0
AND XACT_STATE() <> 0
########RO...
ALTER DATABASE CURRENT SET QUERY_STORE(INTERVAL_LENGTH_MINUTES=1)
Hi redgate team,
the following statement will cause a formatting error:
ALTER DATABASE CURRENT SET QUERY_STORE(INTERVAL_LENGTH_MINUTES=1);
GO
Thanks for looking into this!
Torsten
Friend of Redgate
backup to url
Hi Team,
Formatting the following statement fails
BACKUP DATABASE test
TO URL = 'xyz'
WITH CREDENTIAL ='abc', COMPRESSION, STATS = 10, COPY_ONLY;
GO
Thanks for fixing!
Torsten
Friend of Redgate
ALTER DATABASE SET QUERY_STORE CLEAR ALL
Hi Redgate Team!
The following statement will cause an issue
ALTER DATABASE AdventureWorks2016 SET QUERY_STORE CLEAR ALL
GO
Formatting will add a semicolon after CLEAR which invalids the statement!...