Format procedure parameters

Hi!

Is there a way to format procedure parameters like this?

	Code:
	alter procedure <proc> <param1> , <param2> , ...

I can't find any way to set "alter procedure" format option. Thank you!

Options -> "Code Formatting" tab -> Select your formatting style on the left -> Expand "Commas..." section on the right -> Select "Stacked (leading with indent)" -> Click OK. This should do it.

	SysOp wrote:
	Options -> "Code Formatting" tab -> Select your formatting style on the left -> Expand "Commas..." section on the right -> Select "Stacked (leading with indent)" -> Click OK. This should do it.

Thank you! But this don't work.

Before format:

	Code:
	alter procedure ttt @param1 int, @param2 int, @param3 as

After format:

	Code:
	alter procedure ttt @param1 int , @param2 int , @param3 as

Format code in options:

	Code:
	alter procedure ... @... , @... with ... ,... as <stmtList> go

Please restore the original formatting paterns, what you have now is broken

The original pattern for ALTER PROCEDURE is

	Code:
	ALTER PROCEDURE ... @... @... WITH ..., ... AS <stmtList> GO

Note that keyword casing, commas, and some other elements are not controlled by patterns for individual SQL constructs, they are controlled by separate style scope options

I've changed pattern specialy. Your pattern doesn't solve my problem. I think this is a bag.

It works fine with the factory settings. You may need to undo some of your other changes to make it working again or even better use the Import/Export button in the Options dialog to restore factory default settings for everything.