query to view stored procedure in sql code example

Example: mssql describe stored procedure sqlcmd

sp_helptext <name of your sp>