SQL: Exec sp_sproc_columns @procedure_name='AddUser'

query
  CHAR_OCTET_LENGTH COLUMN_DEF COLUMN_NAME COLUMN_TYPE DATA_TYPE IS_NULLABLE LENGTH NULLABLE ORDINAL_POSITION PRECISION PROCEDURE_NAME PROCEDURE_OWNER PROCEDURE_QUALIFIER RADIX REMARKS SCALE SQL_DATA_TYPE SQL_DATETIME_SUB SS_DATA_TYPE TYPE_NAME
1 [empty string] [empty string] @RETURN_VALUE 5 4 NO 4 0 0 10 AddUser;1 RSilverbergS silverwareconsultingdb 10 [empty string] 0 4 [empty string] 56 int
2 50 [empty string] @UserName 1 12 YES 50 1 1 50 AddUser;1 RSilverbergS silverwareconsultingdb [empty string] [empty string] [empty string] 12 [empty string] 39 varchar
3 100 [empty string] @Email 1 12 YES 100 1 2 100 AddUser;1 RSilverbergS silverwareconsultingdb [empty string] [empty string] [empty string] 12 [empty string] 39 varchar
4 50 [empty string] @Phone 1 12 YES 50 1 3 50 AddUser;1 RSilverbergS silverwareconsultingdb [empty string] [empty string] [empty string] 12 [empty string] 39 varchar
5 50 [empty string] @Password 1 12 YES 50 1 4 50 AddUser;1 RSilverbergS silverwareconsultingdb [empty string] [empty string] [empty string] 12 [empty string] 39 varchar
6 [empty string] [empty string] @UserTypeID 1 4 YES 4 1 5 10 AddUser;1 RSilverbergS silverwareconsultingdb 10 [empty string] 0 4 [empty string] 38 int
7 [empty string] [empty string] @ActiveFlag 1 -7 YES 1 1 6 1 AddUser;1 RSilverbergS silverwareconsultingdb [empty string] [empty string] 0 -7 [empty string] 50 bit
8 2147483647 [empty string] @UserDetails 1 -1 YES 2147483647 1 7 2147483647 AddUser;1 RSilverbergS silverwareconsultingdb [empty string] [empty string] [empty string] -1 [empty string] 35 text
9 [empty string] [empty string] @StartDate 1 11 YES 16 1 8 23 AddUser;1 RSilverbergS silverwareconsultingdb [empty string] [empty string] 3 9 3 111 datetime
10 [empty string] [empty string] @WalletContents 1 3 YES 21 1 9 19 AddUser;1 RSilverbergS silverwareconsultingdb 10 [empty string] 4 3 [empty string] 110 money
11 [empty string] [empty string] @DecimalTest 1 3 YES 12 1 10 10 AddUser;1 RSilverbergS silverwareconsultingdb 10 [empty string] 3 3 [empty string] 106 decimal