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

thomaswoof

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

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.

vpaulson

Did this ever get resolved in a subsequent version of sql prompt?