To Get List of All Stored Procedures Parameter of DataBase In Sql Server,use the following query
select *from sys.all_parameters this script helps to Get List of All Stored Procedures Parameter of DataBase In Sql Server
select *from sys.all_parameters