获取sqlserver存储过程参数列表

SELECT 
 
 AS [Name], 
 
ISNULL(, N'') AS [SystemType], 
 
CAST(CASE WHEN  IN (N'nchar', N'nvarchar') AND param.max_length <> -1 THEN param.max_length/2 ELSE param.max_length END AS int) AS [Length] 
 
FROM 
 
sys.all_objects AS sp 
 
INNER JOIN sys.all_parameters AS param ON param.object_id=sp.object_id 
 
LEFT OUTER JOIN sys.types AS baset ON baset.user_type_id = param.system_type_id and baset.user_type_id = baset.system_type_id 
 
WHERE 
 
(sp.type = N'P' OR sp.type = N'RF' OR sp.type='PC')and(= 
 
N'ProcB_Group_TBSelectList' and SCHEMA_NAME(sp.schema_id)=N'dbo') 
 
ORDER BY 
 
param.parameter_id ASC