# 查询SQLSERVER中所有存储过程
SELECT
Name,
Definition
FROM
sys.sql_modules AS m
INNER JOIN sys.all_objects AS o ON m.object_id = o.object_id
WHERE
o.[type] = 'P'
查询SQLSERVER中所有存储过程
最新推荐文章于 2023-05-16 15:38:42 发布
# 查询SQLSERVER中所有存储过程
SELECT
Name,
Definition
FROM
sys.sql_modules AS m
INNER JOIN sys.all_objects AS o ON m.object_id = o.object_id
WHERE
o.[type] = 'P'