How can we help you today? How can we help you today?

EXEC SP Comma Placement

Hi,

I don't know if I am just missing a setting somewhere but on Format > Commas & parentheses I have it set to 'place comma at start'. This option isn't be respected when auto-fill an execute statement for an SP with parameters. My desire is that the parameter have the commas at the start but instead they are at the end. Example below:
EXEC dbo.MySP @param1 = '',
				@param2 = '',
				@param3 = ''

when I would have expected
EXEC dbo.MySP @param1 = ''
				,@param2 = ''
				,@param3 = ''

SQL Prompt Version 7.2.4.291
SSMS 12.0.2569.0

Thanks
Steve
sdingle
0

Comments

1 comment

Sort by
  • sdingle
    Well it seems to have fixed itself. I changed one of the EXEC setting Inserted Code > Object & Statement > EXEC Statement > Show Parameter Data Types. I unchecked that option and then the commas were placed as expected. Just as a test I re-checked it and the comma placements was 'ok' but the data type comment was off. I am keeping this option unchecked but you might want to look into it
    EXECUTE dbo.mySP
	@Param1 = ''
   , -- varchar(50)
	@Param2 = ''
   , -- varchar(50)
	@Param3 = '' -- varchar(50)
    sdingle
    0

Add comment

Please sign in to leave a comment.