Inline EXEC (possbily) too hard to find?
ben_b
Posts: 84 Silver 2
in SQL Prompt
Hi All. I was debugging a stored proc with ~1000 lines of code and with lots of parameters and temp tables.
I came across the below image on UserVoice and then went down to the comments and found that Inline EXEC did what I needed to do.
My feedback is that it was possibly too hard to find? Would being able to right-click the SP in object explorer and choose something like
"Convert to script" or
"Debug Script"
would this help more people find it? also, the name "Inline Exec" suggests a different use case so probably why i may have glossed over it.
Just some feedback - good feature tho, i would have been using it all the time if I had known.
cheers
Ben
I came across the below image on UserVoice and then went down to the comments and found that Inline EXEC did what I needed to do.
My feedback is that it was possibly too hard to find? Would being able to right-click the SP in object explorer and choose something like
"Convert to script" or
"Debug Script"
would this help more people find it? also, the name "Inline Exec" suggests a different use case so probably why i may have glossed over it.
Just some feedback - good feature tho, i would have been using it all the time if I had known.
cheers
Ben
Tagged:
