SQL: SELECT * FROM INFORMATION_SCHEMA.PARAMETERS
WHERE SPECIFIC_NAME = 'AddUser'


query
  AS_LOCATOR CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH CHARACTER_SET_CATALOG CHARACTER_SET_NAME CHARACTER_SET_SCHEMA COLLATION_CATALOG COLLATION_NAME COLLATION_SCHEMA DATA_TYPE DATETIME_PRECISION INTERVAL_PRECISION INTERVAL_TYPE IS_RESULT NUMERIC_PRECISION NUMERIC_PRECISION_RADIX NUMERIC_SCALE ORDINAL_POSITION PARAMETER_MODE PARAMETER_NAME SCOPE_CATALOG SCOPE_NAME SCOPE_SCHEMA SPECIFIC_CATALOG SPECIFIC_NAME SPECIFIC_SCHEMA USER_DEFINED_TYPE_CATALOG USER_DEFINED_TYPE_NAME USER_DEFINED_TYPE_SCHEMA
1 NO 50 50 [empty string] iso_1 [empty string] [empty string] SQL_Latin1_General_CP1_CI_AS [empty string] varchar [empty string] [empty string] [empty string] NO 0 [empty string] [empty string] 1 IN @UserName [empty string] [empty string] [empty string] silverwareconsultingdb AddUser RSilverbergS [empty string] [empty string] [empty string]
2 NO 100 100 [empty string] iso_1 [empty string] [empty string] SQL_Latin1_General_CP1_CI_AS [empty string] varchar [empty string] [empty string] [empty string] NO 0 [empty string] [empty string] 2 IN @Email [empty string] [empty string] [empty string] silverwareconsultingdb AddUser RSilverbergS [empty string] [empty string] [empty string]
3 NO 50 50 [empty string] iso_1 [empty string] [empty string] SQL_Latin1_General_CP1_CI_AS [empty string] varchar [empty string] [empty string] [empty string] NO 0 [empty string] [empty string] 3 IN @Phone [empty string] [empty string] [empty string] silverwareconsultingdb AddUser RSilverbergS [empty string] [empty string] [empty string]
4 NO 50 50 [empty string] iso_1 [empty string] [empty string] SQL_Latin1_General_CP1_CI_AS [empty string] varchar [empty string] [empty string] [empty string] NO 0 [empty string] [empty string] 4 IN @Password [empty string] [empty string] [empty string] silverwareconsultingdb AddUser RSilverbergS [empty string] [empty string] [empty string]
5 NO [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] int [empty string] [empty string] [empty string] NO 10 10 0 5 IN @UserTypeID [empty string] [empty string] [empty string] silverwareconsultingdb AddUser RSilverbergS [empty string] [empty string] [empty string]
6 NO [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] bit [empty string] [empty string] [empty string] NO 1 [empty string] 0 6 IN @ActiveFlag [empty string] [empty string] [empty string] silverwareconsultingdb AddUser RSilverbergS [empty string] [empty string] [empty string]
7 NO 2147483647 2147483647 [empty string] iso_1 [empty string] [empty string] SQL_Latin1_General_CP1_CI_AS [empty string] text [empty string] [empty string] [empty string] NO 0 [empty string] [empty string] 7 IN @UserDetails [empty string] [empty string] [empty string] silverwareconsultingdb AddUser RSilverbergS [empty string] [empty string] [empty string]
8 NO [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] datetime 3 [empty string] [empty string] NO 23 [empty string] 3 8 IN @StartDate [empty string] [empty string] [empty string] silverwareconsultingdb AddUser RSilverbergS [empty string] [empty string] [empty string]
9 NO [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] money [empty string] [empty string] [empty string] NO 19 10 4 9 IN @WalletContents [empty string] [empty string] [empty string] silverwareconsultingdb AddUser RSilverbergS [empty string] [empty string] [empty string]