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

Insert values

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

  • Options
    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.