view the logic behind procedure in SQL Server

SELECT OBJECT_NAME(o.object_id), c.text FROM sys.syscomments c
join sys.objects o on o.object_id = c.id
where o.type= 'P' and name = 'SP Name '
GO

sp_helptext 'SP Name '