Posts
Sort by recent activity
RAISERROR
Hi Redgate Team,the RaiseError is formatted incorrectly[code]IF ( @FullScan = 1 AND @Resample = 1 ) BEGIN RAISERROR('Either update statistics with the FullScan or Resample option.', 16, 1...
Tabs everywhere
Hi Team,[code]SELECT @product_version = CONVERT(varchar(50), SERVERPROPERTY('PRODUCTVERSION'));SET @autostat_legacy_behavior = CASE WHEN ( CONVERT(smallint,...
Cross Join
Hi Redgate Team,It seems that CROSS JOIN is not formatted correctly - it should follow the JOIN formatting style.[code]USE AdventureWorks2017;GOSELECT TOP 100 a.SalesOrderID, a.SalesOrderDeta...
Additional Space after TO
Hi Redgate Team,SQL Prompt will add an additional space after TO [code]:SETVAR BackupPath "C:\Program Files\Microsoft SQL Server\MSSQL14.MYSQLSERVER2017\MSSQL\Backup\"BACKUP LOG AdventureWorks2017 ...
Not breaking between
Hi Redgate Team,the following code is formatted like this:CREATE TABLE test ( col1 int IDENTITY(1, 1) NOT NULL, col2 char(2000) NOT NULL
DE...
Semicolon
Hi redgate Team,I though this was fixed already.In the latest version it pops up again:[code]-- Create a tableDROP TABLE IF EXISTS test;GOCREATE TABLE test ( col1 int NOT NULL, col2 int NOT NULL );...
Alignment
Hi!SQL prompt will format the following code like this[code]-- Insert 10 recordsWITH cteAS ( SELECT numbers.col1 FROM ( VALUES ( 0 ) , ( 1 ) , ...
! Error refactoring unicode strings
Hi!After upgrading to the latest version I got the mentioned error for every! SQL code line I would like to format.I consider this as a critical bug cause I cannot use SQL Prompt anymore.Would be n...
Tabs
Hi Redgate Team,SQL Prompt will tabs between:[code] ALTER TABLE #SOURCE_ELEMENTS ADD PRIMARY KEY ( ELEMENT_UID, HASH_SHA1 );[/code]Thanks for fixin...
Alignment
Hi Redgate Team,SQL Prompt formats the following code like this:[code]CREATE TABLE #SYNTOSA_ELEMENTS( LEVEL int NOT NULL, ELEMENT_UID uniqueidentifier NOT NULL, ELEMENT_UID_PARENT uniqueid...