Posts
Sort by recent activity
Tabs
Hi Redgate Team,
SQL prompt adds tabs between the ORDER BY which is not my intention:
WITH c
AS
(
SELECT
LAG(cntr_timestamp, 1) OVER ( PARTITION BY counter_name ORDER BY
cntr_tim...
IIF
Hi Redgate Team,
SQL Prompt formats the following code like this
SELECT
iteration, file_id, NAME, vlf_sequence_number, vlf_active, vlf_create_lsn
FROM dbo.db_log_info
ORDER BY
iteration
, IIF (v...
Constraint format
Hi Redgate Team,
SQL Prompt formats the following code like:
ALTER TABLE SYNTO.RPT_ELEMENT
ADD
CONSTRAINT PKCL_RPT_ELEMENT_ID_RPT_ELEMENT_ELEMENT_TYPE_FUNCTION_NAME_ELEMENT_UID_ELEMENT_ISACTIVE PR...
Additional AS
Hi Redgate Team,
SQL Prompt will add an AS in the end formatting the following code
SELECT ((4.2 * 29) + 68 )* 8 + (6 * 34)
SELECT ((4.2 * 29) + 68 )* 8 + (6 * 34) AS
Version 9.0.9.3951
Than...
Error laying out SQL
Hi Redgate Team,
formatting the following code will cause the error "Error laying out SQL"
The S from Select is highlighted and the error Object reference not set to an instance of an object.
SELEC...
Alignment
Hi Redgate Team,
this following code is formatted like shown:ALTER TABLE SENTOSA.COMPONENTS_TO_MIGRATE
ADD
CONSTRAINT UQ_COMPONENTS_TO_MIGRATE_COMPONENT_COMPONENT_NAME_COMPONENT_TYPE_PARENT_ID_DOM...
Comment Alignment
Hi Redgate Team!
Comments are not formatted properly: /*
Test
*/
This will formatted like this:/*
Test
*/
*/ should be aligned with the /*.
Thanks for looking into this!
Torsten
Missing Semicolon
Hi Redgate Team,
SQL Prompt is not adding semicolons:
DROP TABLE IF EXISTS file_statistics_3;
DROP TABLE IF EXISTS file_size_3 -- missing one
DROP TABLE IF EXISTS waits_3 -- missing one
GO
Woul...
WITH TABLERESULTS
Hi Redgate Team,
the following code causes an formatting error:-- Dump the BCM page
DBCC TRACEON(3604,-1)
DBCC PAGE(BulkLogged,1,7,3) WITH TABLERESULTS --Fail
GO
Would be nice if you can fix thi...
WITH INIT, TO
Hi Redgate Team,
After formatting the following code the INIT is sent to the end of the next line, which is wrong.
Additionally you can see that an unneeded space is added after TO.:SETVAR BackupPa...