sqlserver查询存储过程和执行

1.查询库中全部存储过程
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’

2.查询存储过程
EXEC dbo.Text @ID = N’单号123’, @Name = N’名称哈哈’;