What are the challenges you face when working across database platforms? Take the survey
Options

formatting values

edited February 18, 2017 5:28AM in SQL Prompt
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

Comments

  • Options
    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
    Technical Lead, SQL Monitor
  • Options
    Hi Torsten,

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

    Thanks,
    Michael
    Michael Clark
    Technical Lead, SQL Monitor
  • Options
    Hi Michael,

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

    Torsten
Sign In or Register to comment.