pr_CustomersAndOrdersOnCountry
Parameters
| Parameter name |
Ordinal |
Native type |
Length |
Precision |
Scale |
Direction |
Is result-set |
| @country |
1 |
varchar |
50 |
0 |
0 |
Input |
|
Model elements mapped on this stored procedure
Result sets
Resultset1
Fields
| Field name |
Ordinal |
Native type |
Length |
Precision |
Scale |
Is Nullable |
| CustomerID |
1 |
nchar |
5 |
0 |
0 |
|
| CompanyName |
2 |
nvarchar |
40 |
0 |
0 |
|
| ContactName |
3 |
nvarchar |
30 |
0 |
0 |
Yes |
| ContactTitle |
4 |
nvarchar |
30 |
0 |
0 |
Yes |
| Address |
5 |
nvarchar |
60 |
0 |
0 |
Yes |
| City |
6 |
nvarchar |
15 |
0 |
0 |
Yes |
| Region |
7 |
nvarchar |
15 |
0 |
0 |
Yes |
| PostalCode |
8 |
nvarchar |
10 |
0 |
0 |
Yes |
| Country |
9 |
nvarchar |
15 |
0 |
0 |
Yes |
| Phone |
10 |
nvarchar |
24 |
0 |
0 |
Yes |
| Fax |
11 |
nvarchar |
24 |
0 |
0 |
Yes |
Model elements mapped on this resultset
Resultset2
Fields
| Field name |
Ordinal |
Native type |
Length |
Precision |
Scale |
Is Nullable |
| OrderID |
1 |
int |
0 |
10 |
0 |
|
| CustomerID |
2 |
nchar |
5 |
0 |
0 |
Yes |
| EmployeeID |
3 |
int |
0 |
10 |
0 |
Yes |
| OrderDate |
4 |
datetime |
0 |
0 |
0 |
Yes |
| RequiredDate |
5 |
datetime |
0 |
0 |
0 |
Yes |
| ShippedDate |
6 |
datetime |
0 |
0 |
0 |
Yes |
| ShipVia |
7 |
int |
0 |
10 |
0 |
Yes |
| Freight |
8 |
money |
0 |
19 |
4 |
Yes |
| ShipName |
9 |
nvarchar |
40 |
0 |
0 |
Yes |
| ShipAddress |
10 |
nvarchar |
60 |
0 |
0 |
Yes |
| ShipCity |
11 |
nvarchar |
15 |
0 |
0 |
Yes |
| ShipRegion |
12 |
nvarchar |
15 |
0 |
0 |
Yes |
| ShipPostalCode |
13 |
nvarchar |
10 |
0 |
0 |
Yes |
| ShipCountry |
14 |
nvarchar |
15 |
0 |
0 |
Yes |
Model elements mapped on this resultset