获取SqlServer存储过程定义的3种方法

declare @p_text varchar(max)

SELECT @p_text= text 
FROM syscomments 
WHERE id = ( SELECT id FROM sysobjects WHERE name = ' 存储过程名称 ')

print @p_text

declare @p_text varchar(max)
SELECT @p_text= definition FROM sys.sql_modules 
JOIN sys.objects ON sys.sql_modules.object_id=sys.objects.object_id --and type='P' 
and sys.objects.name='sp_MSupd_dboInd_IndependenceReportTo' 

print @p_text