---2005 SELECT 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='存储过程名';
1、 2005 or 2008 or 2008r2 SELECT sm.object_id, OBJECT_NAME(sm.object_id) AS object_name, o.type, o.type_desc, sm.definition FROM sys.sql_modules AS sm JOIN sys.objects AS o ON sm.object_id = o.object_id where o.type='p' and o.name='存储过程名';2、存储过程依赖库,而不是表。
select text
from syscomments
SELECT 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='存储过程名';
2005 or 2008 or 2008r2
SELECT sm.object_id, OBJECT_NAME(sm.object_id) AS object_name, o.type, o.type_desc, sm.definition
FROM sys.sql_modules AS sm
JOIN sys.objects AS o ON sm.object_id = o.object_id
where o.type='p' and o.name='存储过程名';2、存储过程依赖库,而不是表。
sp_help '存储过程名'
--返回结果则是。
对未加密的过程,可通过查询syscomments系统表得到.
简单方法:在企业管理器中就可查到自己编写的存储过程宜自己保存