Comments
3 comments
-
First, which version are you using. Prompt revs so often that "latest" is hard to know.
I don't know we can do this exactly. If you edit formatting styles, there is an INSERT item on the left.
Under here, I think the last item in the first row matches closely to what you want with the always option selected. We don't have a good option to only put the first item on the end of the line. That seems like an option that inconsistently lists items to me, but that may be what you want. I'd suggest you add this to Uservoice if it's important to you.
Below that, the VALUES item list, second item in second row, might be what helps you with the Values clause.
-
Thank you for pointing me to the correct place. I had looked there before the did not realize there were more settings below which was for the VALUES keyword. I maximized the window this time was able to see the new settings you pointed out. I had to set it to always place each 'value" on a separate line and now I am much closer to getting it matching previous format layouts.
My version is 8.2.5.2924 used in SSMS. Thanks again! Very much appreciated. -
You are welcome. Glad to help.
Add comment
Please sign in to leave a comment.
Previous formatting using SQL Prompt
INSERT INTO [dbo].[user_name_filter]
( [accnt_id],
[user_id_key],
[filter_id],
[field_id],
[operand],
[query_value] )
VALUES ( @accnt_id,
@user_id_key,
@filter_id,
@field_id,
@operand,
ISNULL(@query_value, '') )
Current formatting using LATEST SQL Prompt
INSERT INTO [dbo].[user_name_filter] ([accnt_id],
[user_id_key],
[filter_id],
[field_id],
[operand],
[query_value])
VALUES (@accnt_id, @user_id_key, @filter_id, @field_id, @operand, ISNULL(@query_value, ''));