Posts
Sort by recent activity
ALTER TABLE REBUILD fails
Hi Redgate Team,
Formatting the statement will fail:
ALTER TABLE dbo.Heap REBUILD;
GO
Thanks for looking into this!
Torsten
Friend of Redgate
Error : laying out SQL
Hi Team,
trying to format the following batch will cause the mentioned error and the first line (-- Insert role user permission) is highlighted.
-- Insert role user permission
-- This table is just...
ADD (column)
Hi Team,
The following statement is formatted this way:
-- Add seven additional bit columns (9)
ALTER TABLE dbo.FixedColumnBit
ADD
col3 bit NULL
, col4 bit NULL
, col5 bit NULL
, col6 bit NULL
, co...
WITH STATISTICS_ONLY
Hi Team,
the following statement will cause a formatting error:
CREATE CLUSTERED INDEX CL_SalesOrderDetail_ProductID
ON dbo.SalesOrderDetail (ProductID)
WITH STATISTICS_ONLY = -1
GO
Thanks for fixi...
WHERE
Hi Team,
SELECT * FROM missingIndex WHERE
......col1 > 0 AND col2 > 0
GO
The WHERE clause is not send to a new line which seems to be a bug.
Just make a copy of your(!) default style and change
Dat...
parenthesis
Hi!
I am wondering if the formatting of the following statement is intended:IF EXISTS (
SELECT * FROM sys.server_event_sessions WHERE name = 'Waits'
)
DROP EVENT SESSION Waits ON SERVER;
GO
...
Insert values
Hi!
It seems to be impossible to allign the first value in the value list to the succeeding.
Also brackets and tabs are not working as expected.INSERT dbo.IAMPage
(
col1
, col2
, col3
)
VALUES
(
...
MIXED_PAGE_ALLOCATION
Hi !
The setting MIXED_PAGE_ALLOCATION is not covered by the intellisense:-- Enable mixed page allocation
ALTER DATABASE extent_management SET MIXED_PAGE_ALLOCATION ON;
GO
Thanks for fixing this!
formatting values
Hi!
Seems it is impossible to allign the first value in the values clause to the second value.
Would be nice to fix it - thanks!DROP TABLE IF EXISTS RowOffsetArray;
GO
CREATE TABLE dbo.RowOffsetAr...
create database
HI!
Formatting the following statement will cause some issues::SETVAR DataPath "C:Program FilesMicrosoft SQL ServerMSSQL13.MYSQLSERVER2016MSSQLDATA"
:SETVAR LogPath "C:Program FilesMicrosoft SQL Se...