Added ability to script a stored procedure parameters with their defaults and comments. Need help with checkin process. #20871
iccosupport-ship-it
started this conversation in
Ideas
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Hi,
I submitted a fork that gives the extension the following feature. I am a bit confused as to the process to contribute, even after reading the wiki and readme. I submitted my changes via a Fork. Is this the way to do it? Thank you.
Added ability to script the parameters of a stored procedure by putting the cursor in the editor over the name of a stored procedure and clicking Ctrl-Alt-P.
Also added right-click on a stored procedure in Object Explorer and allow new command "Script as execute with parameters".
The parameters have the defaults in them (otherwise NULL), and the datatype and direction are expressed as comments. Also, any comments to the right of the parameter in the procedure declaration will appear the same way in the scripted parameters, above the parameter name.
Beta Was this translation helpful? Give feedback.
All reactions