formatting values

torsten.strauss

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.RowOffsetArray (col1 int NOT NULL);
GO

-- Insert 20 records
INSERT	dbo.RowOffsetArray
(
	col1
)
VALUES
(4)
, (12)
, (6);
GO

Michael Clark

Hi Torsten,

Our formatting system aligns the first value clause to the second value by default:

IF OBJECT_ID('RowOffsetArray', 'U') IS NOT NULL
    DROP TABLE RowOffsetArray;
GO

CREATE TABLE dbo.RowOffsetArray ( col1 INT NOT NULL );
GO

-- Insert 20 records
INSERT  dbo.RowOffsetArray ( col1 )
VALUES  ( 4 )
,       ( 12 )
,       ( 6 );
GO

Could you confirm that you are using our new beta formatting system?

In the new beta formatting system, we tried to align the first value in the values clause to the second value and it doesn't seem to be possible.

We will add this to our formatting backlog of items to consider before releasing the full version.

Thanks,
Michael

Michael Clark

Hi Torsten,

We have added this to our backlog - reference SP-6070.

Thanks,
Michael

torsten.strauss

Hi Michael,

thanks for looking into this!
Yes, I use the latest beta version.

Torsten