SqlServer查看存储过程定义语句

SELECT definition
FROM DBName.sys.sql_modules
WHERE object_id = (OBJECT_ID(N'DBName.dbo.SP_NAME‘))