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 |