What are the challenges you face when working across database platforms? Take the survey
Options

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

thomaswoofthomaswoof Posts: 2
edited December 9, 2013 6:06AM in SQL Prompt
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

Comments

Sign In or Register to comment.