Posts
Sort by recent activity
Semicolon after GO
Hi Redgate Team,ALTER DATABASE AdventureWorks2016
SET QUERY_STORE CLEAR ALL
GO
will be formatted as
ALTER DATABASE AdventureWorks2016
SET QUERY_STORE CLEAR ALL
GO
;
I guess adding the semicolon...
Alignment for list of columns of a constraint in create table statement
Hi Redgate Team,
the alignment of the column list within a constraint is wrong:CREATE TABLE test
(
col______________1 int NOT NULL
, col______________2 int NOT NULL
, col______________3 int...
Spaces
Hi Redgate Team,
SQL Prompt adds a few additional spaces (or tabs) between variable name and data type sometimes.
I have no clue where why this is the case for a few of the variables and for others...
Alignment
Hi Redgate Team!
After the last update the alignment seems to be wrong.
SELECT_*
FROM___sys.fn_dblog (NULL, NULL)
WHERE
_________[Transaction ID] IN (SELECT [Transaction ID] FROM
sys.fn_dblog ('359...
Add spaces around parentheses contents
Hi Redgate Team,
The option Parentheses / Spaces / Add spaces around parentheses contents will add spaces / tab where it shouldn't.
-- enabled
SELECT *
FROM sys.fn_dblog (NULL, NULL)
WHERE
[Transac...
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...