Extending Summarise Script
ben_b
Posts: 84 Silver 2
in SQL Prompt
Posting here instead of UserVoice because a screenshot helps explain it.
Summarise script is a good feature. I often encounter SPs with 20+ statements. It would be nice if the logic already built into Summarise Script could generate 'Step #1 - xxx' comments for each statement as having the step number really helps me to understand what i'm looking at for large procs...
alternatively, if it could generate a the list of steps as a comment that we could stick at the top of the SP to document it, that would be helpful as well - even if it isn't perfect it would be really helpful to automate the bulk of it and the developer could tweak it to make it even more useful for other developers.
Summarise script is a good feature. I often encounter SPs with 20+ statements. It would be nice if the logic already built into Summarise Script could generate 'Step #1 - xxx' comments for each statement as having the step number really helps me to understand what i'm looking at for large procs...
alternatively, if it could generate a the list of steps as a comment that we could stick at the top of the SP to document it, that would be helpful as well - even if it isn't perfect it would be really helpful to automate the bulk of it and the developer could tweak it to make it even more useful for other developers.
/* SP : dataset.usp_Example
Step #01 - INSERT INTO dbo.xyz
Step #02 - UPDATE dbo.abc
Step #03 - OPEN cursor_n
Step #04 - SELECT INTO #qwerty
*/
not sure how useful it would be - just chucking the idea into the ether.
not sure how useful it would be - just chucking the idea into the ether.
Tagged:
