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

Provides intelligent code completion for SQL Server editors.

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

Postby thomaswoof » Fri Dec 06, 2013 7: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?

Posts: 1
Joined: Wed Aug 28, 2013 1:29 pm

Postby Anu Deshpande » Mon Dec 09, 2013 11:06 am

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.
Anu Deshpande
Posts: 839
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

Return to SQL Prompt

Who is online

Users browsing this forum: No registered users and 0 guests