How can we help you today? How can we help you today?

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

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

Comments

3 comments

  • 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
    0
  • Michael Clark
    Hi Torsten,

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

    Thanks,
    Michael
    Michael Clark
    0
  • torsten.strauss
    Hi Michael,

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

    Torsten
    torsten.strauss
    0

Add comment

Please sign in to leave a comment.