[FR] Comma at beginning of line for Stored Procedure Params

swrobel

When I tab-complete a stored procedure name after typing EXEC in SQL Prompt, it expands all of the parameters out for me, which is great. However, it looks like this:

EXEC Test
	@Param_1 = 1, --  int
	@Param_2 = 2 --  int

The problem is that the comma is at the end of each preceding line, rather than at the beginning of the next line, which I would say is not best practice if you want to delete a parameter from the list (common when you have a parameter that has a default value, usually at the end). The fix is pretty simple, and it should look like this:

EXEC Test
	@Param_1 = 1 --  int
,  @Param_2 = 2 --  int

FYI, for @Param_2 it should be ,<tab>@Param_2

tanya

Hi,

You make a valid point. I will log this in as a request and see what we can do about it.

Thanks,
Tanya

MikeONeill

Hi

Without "punting" another Red Gate Product ( which I will !!) have you looked at SQL Refactor , which you can configure very flexibly to position columns all in one line , or new line etc , pre comma's post comma's , and loads more

Its a nice tool to "Order the Mess" of a lot of stored procs I have seen ..

Even some of my own

"Write scruffy , tidy up once your'e done" -- probbaly not quite best practice but >>>


Mike