Insert values

torsten.strausstorsten.strauss Posts: 271 Silver 3
edited February 13, 2017 6:49AM in SQL Prompt
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
(
	REPLICATE('d', 5000)
	, REPLICATE('e', 5000)
	, REPLICATE('f', 8000)
)

, (
	REPLICATE('g', 5000)
,	REPLICATE('h', 5000)
,	REPLICATE('i', 8000)
)

Should look like:
INSERT	dbo.IAMPage
(
	 col1
,	col2
,	col3
)
VALUES
(
	 REPLICATE('d', 5000)
,	REPLICATE('e', 5000)
,	REPLICATE('f', 8000)
)
, 
(
	 REPLICATE('g', 5000)
,	REPLICATE('h', 5000)
,	REPLICATE('i', 8000)
)

Comments

  • Hi Torsten,

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

    We will add this to our formatting backlog of items to consider before releasing the full version (reference SP-6070).

    Thanks,
    Michael
    Michael Clark
    Technical Lead, SQL Monitor
Sign In or Register to comment.