INLICE EXEC SQL

In MS SQL Server 2017
When I highlight some sql
and right click

What is EXEC INLINE ??
Larry Bristersr. DeveloperAsked:
Who is Participating?
 
Aneesh RetnakaranDatabase AdministratorCommented:
I thought thats a feature came with red-gate sql prompt . This is a great option for debugging the sps and udfs.
for instance you need to debug the sp all

exec usersp @param1 =2, @param2 =  

when you want to debug this sp call, just  right click on the sp call and choose the "Inline Exec" option.  Sp call will be replaced with the source code of the sp and the variables will be assigned properly
0
 
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
I thought thats a feature came with red-gate sql prompt .

You're correct. This is not a standard Microsoft SQL Server Management Studio functionality.

(no points please).
0
 
Larry Bristersr. DeveloperAuthor Commented:
Perfect! Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.