MSSQL - How to check if stored procedure exists, and if exists display its definition

Watch this example on YouTube:


If Exists(Select * from sys.objects where type = 'P' and name = 'spTest')
select OBJECT_DEFINITION (Object_Id(N'spTest'));