It might be already known to you but I thought for sharing because I frequently use this command and it is very useful command.
When someone wants to determine detail of a function or stored procedure he/she can use this useful command.
The syntax is very simple. Just write
sp_helptext Storedprocedure/ functionname
For example If I want to determine detail of a stored procedure “proc_FindStudentUsingCorrect” then I have to write following command
sp_helptext proc_FindStudentUsingCorrect
see below snap for detail
You can now copy the result text and check what exactly written in the stored procedure or function.
I hope you will use it in your day to day practice.
Enjoy!!!
RJ
