SQL code to open a stored procedure and read it in SQL Server

Question

I use an interface that allows me to use only SQL commands. The database is SQL Server. Now I need to open the stored procedure and read what is inside it. What is an SQL command to open a stored procedure for reading? Thanks.

Answer 1

SELECT definition FROM sys.sql_modules WHERE object_id = OBJECT_ID('YourSchemaName.YourProcedureName') 

Answer 2

 sp_helptext 'dbo.myStoredProc' 

Answer 3

 SELECT OBJECT_DEFINITION(OBJECT_ID('dbo.myStoredProc')) 

Note: subject to Visibility of metadata and SEE DEFINITION of the right

Answer 4

 SELECT TEXT FROM syscomments WHERE id = (SELECT id FROM sysobjects WHERE name = '<NAME>') ORDER BY colid