view stored procedure sql server code example

Example: mssql describe stored procedure sqlcmd

sp_helptext <name of your sp>