Tuesday, 27 September 2016

How to get definition of Stored Procedure in Sql Server


If you have a stored procedure name "GetStudents" and you want to get it's defintion then
you need to write:

sp_helptext  'GetStudents' 

so syntax is : sp_helptext <your stored procedure name>