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

Formatting - placing stored proc parameters on new line(s)

I'd like my stored procedures to be formatted as:

CREATE PROC [someProc]
(
[tab]@someParameter [datatype]
[tab],@anotherParameter [datatype]
)

but when the proc only has one parameter, it's putting it on the same line as the CREATE/ALTER statement:

CREATE PROC [someProc] @someParameter [datatype]

I can live without the parentheses, but not having the parameters always in the same place messes with me. I looked through the formatting options, the help file, and search the forums, haven't found anything. Am I missing something?

Thanks!
-Thomas
thomaswoof
0

Comments

2 comments

Sort by
  • Anu D
    Thanks for your post.

    You are right this isn't possible at the moment but I have logged this in our internal tracking system whose tracking id is SP-4963.

    Product Manager will review this for a future release of SQL Prompt.
    Anu D
    0
  • vpaulson
    Did this ever get resolved in a subsequent version of sql prompt?
    vpaulson
    0

Add comment

Please sign in to leave a comment.