Formatting of the invocation of a stored procedure
Hi there. Currently, SQL Prompt formats an invocation of a sproc like this:
exec sproc @param1 = ?,
@param2 = ?,
@param3 = ?
I'd like to be able to change this into:
exec sproc
@param1 = ?,
@param2 = ?,
@param3 = ?
Thanks.
Darek
shared this idea
-
Jeff Humphreys
commented
I'm not sure what Chad is suggesting, and if it's a workaround, more explanation or example would help.
-
DBAJohnny
commented
I appreciate all the provided formatting controls for DML, DDL, functions, etc. I have never been able to find any controls for formatting the execution of stored procedures.
For example, in the the attached .png you can see how SQLPrompt natively formats exec statements, and our standard for the same.
-
Chad commented
@Darek, 4 spaces puts the text into a code block. You can put 4 spaces before each line of SQL to put it into a code block, and then add 4 more spaces in front of each line you want to be "tabbed" in.
-
Darek
commented
Of course, the code has not been formatted the way I wanted. There should be 4 spaces before the @param's in the examples.
