t-sql query stored procedure definition code example

Example 1: sp_helptext

sp_helptext proc_name

Example 2: mssql describe stored procedure sqlcmd

sp_helptext <name of your sp>