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

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?



Sign In or Register to comment.