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

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

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

Postby thomaswoof » Fri Dec 06, 2013 8:23 pm

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
 
Posts: 1
Joined: Wed Aug 28, 2013 2:29 pm

Postby Anu Deshpande » Mon Dec 09, 2013 12:06 pm

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.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Prompt 6

Who is online

Users browsing this forum: David Priddle and 1 guest