[MSSQL] Stored Procedure(SP) 파라미터 정보보기

[MSSQL] Stored Procedure(SP) 파라미터 정보보기

DECLARE @ProcedureName VARCHAR(MAX) = 'SP명' SELECT 'PARAMETER_NAME' = A.NAME, 'TYPE' = TYPE_NAME(A.USER_TYPE_ID), 'LENGTH' = A.MAX_LENGTH, 'NULLABLE' = T.IS_NULLABLE, 'PREC' = CASE WHEN TYPE_NAME(A.SYSTEM_TYPE_ID) = 'UNIQUEIDENTIFIER' THEN A.PRECISION ELSE ODBCPREC(A.SYSTEM_TYPE_ID, A.MAX_LENGTH, A.PRECISION) END, 'SCALE' = ODBCSCALE(A.SYSTEM_TYPE_ID, A.SCALE), 'PARAM_ORDER' = A.PARAMETER_ID, 'COLLATION' = CONVERT(SYSNAME, CASE WHEN A.SYSTEM_TYPE_ID IN (35, 99, 167, 175, 231, 239) THEN SERVERPROPERTY('COLLATION') END) FROM SYS.PARAMETERS A INNER JOIN SYS.TYPES AS T ON T.SYSTEM_TYPE_ID = A.SYSTEM_TYPE_ID AND T.USER_TYPE_ID = A.USER_TYPE_ID WHERE OBJECT_ID = OBJECT_ID(@PROCEDURENAME)