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

dmckee11

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

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

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.