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

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()
);
dmckee11
0

Comments

2 comments

Sort by
  • James R
    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
    James R
    0
  • dmckee11
    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.
    dmckee11
    0

Add comment

Please sign in to leave a comment.