How can I change the style for insert Values to be Placed subsequent items on a new line?

I would like all my subsequent Values to be placed on a new line. I see where I can do this for Lists. But I also want this to be done for my Values when I do an Insert.

example of how code looks:
INSERT (
PharmacyId
,OrderListTypeId
,SearchId
,PackageSize
,CreatedById
,CreatedDate
)
VALUES (
cte.Id, cte.OrderListTypeId, cte.SearchId, cte.PackageSize, 1, GETDATE()
);

This is how I would like it to look:
INSERT (
PharmacyId
,OrderListTypeId
,SearchId
,PackageSize
,CreatedById
,CreatedDate
)
VALUES (
cte.Id
,cte.OrderListTypeId
,cte.SearchId
,cte.PackageSize
,1
,GETDATE()
);
Tagged:

Best Answers

  • James RJames R Posts: 104 Silver 4
    Accepted Answer
    Hi @dmckee11 ,

    What version of SQL Prompt are you using? We recently released version 8.2 which contains new formatting options for both INSERTS and VALUES.

    Hope this helps!
    James
    Software Engineer
    Redgate Software
  • dmckee11dmckee11 Posts: 4 New member
    Accepted Answer
    I had 8.1..... I ran the update to receive 8.2 and found the Values section for Insert Statement and was able to choose my desired layout. Thank you.
Sign In or Register to comment.