Wednesday, 30 May 2012

sp_helptext

sp_helptext is a system stored procedure in sql server which is used to find the definition or structure of a stored procedure.

syntax for sp_helptext is:

sp_helptext <stored procedure Name>


Example:

Here is an example for the usage of sp_helptext to find out the definition of USP_CLASS_OF_STUD stored procedure.





No comments:

Post a Comment