Columns
-
ShipName[nvarchar](40) NULL
-
ShipAddress[nvarchar](60) NULL
-
ShipCity[nvarchar](15) NULL
-
ShipRegion[nvarchar](15) NULL
-
ShipPostalCode[nvarchar](10) NULL
-
ShipCountry[nvarchar](15) NULL
-
CustomerID[nchar](5) NULL
-
CustomerName[nvarchar](40) NOT NULL
-
Address[nvarchar](60) NULL
-
City[nvarchar](15) NULL
-
Region[nvarchar](15) NULL
-
PostalCode[nvarchar](10) NULL
-
Country[nvarchar](15) NULL
-
Salesperson[nvarchar](31) NOT NULL
-
OrderID[int] NOT NULL
-
OrderDate[datetime] NULL
-
RequiredDate[datetime] NULL
-
ShippedDate[datetime] NULL
-
ShipperName[nvarchar](40) NOT NULL
-
ProductID[int] NOT NULL
-
ProductName[nvarchar](40) NOT NULL
-
UnitPrice[money] NOT NULL
-
Quantity[smallint] NOT NULL
-
Discount[real] NOT NULL
-
ExtendedPrice[money] NULL
-
Freight[money] NULL
Definition
Sample Data
ShipName
ShipAddress
ShipCity
ShipRegion
ShipPostalCode
ShipCountry
CustomerID
CustomerName
Address
City
Region
PostalCode
Country
Salesperson
OrderID
OrderDate
RequiredDate
ShippedDate
ShipperName
ProductID
ProductName
UnitPrice
Quantity
Discount
ExtendedPrice
Freight
Vins et alcools Chevalier
59 rue de l'Abbaye
Reims
NULL
51100
France
VINET
Vins et alcools Chevalier
59 rue de l'Abbaye
Reims
NULL
51100
France
Steven Buchanan
10248
Federal Shipping
11
Queso Cabrales
14
12
NULL
168
32.38
Vins et alcools Chevalier
59 rue de l'Abbaye
Reims
NULL
51100
France
VINET
Vins et alcools Chevalier
59 rue de l'Abbaye
Reims
NULL
51100
France
Steven Buchanan
10248
Federal Shipping
42
Singaporean Hokkien Fried Mee
9.8
10
NULL
98
32.38
Vins et alcools Chevalier
59 rue de l'Abbaye
Reims
NULL
51100
France
VINET
Vins et alcools Chevalier
59 rue de l'Abbaye
Reims
NULL
51100
France
Steven Buchanan
10248
Federal Shipping
72
Mozzarella di Giovanni
34.8
5
NULL
174
32.38
Toms Spezialitäten
Luisenstr. 48
Münster
NULL
44087
Germany
TOMSP
Toms Spezialitäten
Luisenstr. 48
Münster
NULL
44087
Germany
Michael Suyama
10249
Speedy Express
14
Tofu
18.6
9
NULL
167.4
11.61
Toms Spezialitäten
Luisenstr. 48
Münster
NULL
44087
Germany
TOMSP
Toms Spezialitäten
Luisenstr. 48
Münster
NULL
44087
Germany
Michael Suyama
10249
Speedy Express
51
Manjimup Dried Apples
42.4
40
NULL
1696
11.61
Hanari Carnes
Rua do Paço, 67
Rio de Janeiro
RJ
05454-876
Brazil
HANAR
Hanari Carnes
Rua do Paço, 67
Rio de Janeiro
RJ
05454-876
Brazil
Margaret Peacock
10250
United Package
41
Jack's New England Clam Chowder
7.7
10
NULL
77
65.83
Hanari Carnes
Rua do Paço, 67
Rio de Janeiro
RJ
05454-876
Brazil
HANAR
Hanari Carnes
Rua do Paço, 67
Rio de Janeiro
RJ
05454-876
Brazil
Margaret Peacock
10250
United Package
51
Manjimup Dried Apples
42.4
35
0.15000000596046448
1261.4
65.83
Hanari Carnes
Rua do Paço, 67
Rio de Janeiro
RJ
05454-876
Brazil
HANAR
Hanari Carnes
Rua do Paço, 67
Rio de Janeiro
RJ
05454-876
Brazil
Margaret Peacock
10250
United Package
65
Louisiana Fiery Hot Pepper Sauce
16.8
15
0.15000000596046448
214.2
65.83
Victuailles en stock
2, rue du Commerce
Lyon
NULL
69004
France
VICTE
Victuailles en stock
2, rue du Commerce
Lyon
NULL
69004
France
Janet Leverling
10251
Speedy Express
22
Gustaf's Knäckebröd
16.8
6
0.05000000074505806
95.76
41.34
Victuailles en stock
2, rue du Commerce
Lyon
NULL
69004
France
VICTE
Victuailles en stock
2, rue du Commerce
Lyon
NULL
69004
France
Janet Leverling
10251
Speedy Express
57
Ravioli Angelo
15.6
15
0.05000000074505806
222.3
41.34
Victuailles en stock
2, rue du Commerce
Lyon
NULL
69004
France
VICTE
Victuailles en stock
2, rue du Commerce
Lyon
NULL
69004
France
Janet Leverling
10251
Speedy Express
65
Louisiana Fiery Hot Pepper Sauce
16.8
20
NULL
336
41.34
Suprêmes délices
Boulevard Tirou, 255
Charleroi
NULL
B-6000
Belgium
SUPRD
Suprêmes délices
Boulevard Tirou, 255
Charleroi
NULL
B-6000
Belgium
Margaret Peacock
10252
United Package
20
Sir Rodney's Marmalade
64.8
40
0.05000000074505806
2462.4
51.3
Suprêmes délices
Boulevard Tirou, 255
Charleroi
NULL
B-6000
Belgium
SUPRD
Suprêmes délices
Boulevard Tirou, 255
Charleroi
NULL
B-6000
Belgium
Margaret Peacock
10252
United Package
33
Geitost
2
25
0.05000000074505806
47.5
51.3
Suprêmes délices
Boulevard Tirou, 255
Charleroi
NULL
B-6000
Belgium
SUPRD
Suprêmes délices
Boulevard Tirou, 255
Charleroi
NULL
B-6000
Belgium
Margaret Peacock
10252
United Package
60
Camembert Pierrot
27.2
40
NULL
1088
51.3
Hanari Carnes
Rua do Paço, 67
Rio de Janeiro
RJ
05454-876
Brazil
HANAR
Hanari Carnes
Rua do Paço, 67
Rio de Janeiro
RJ
05454-876
Brazil
Janet Leverling
10253
United Package
31
Gorgonzola Telino
10
20
NULL
200
58.17
Hanari Carnes
Rua do Paço, 67
Rio de Janeiro
RJ
05454-876
Brazil
HANAR
Hanari Carnes
Rua do Paço, 67
Rio de Janeiro
RJ
05454-876
Brazil
Janet Leverling
10253
United Package
39
Chartreuse verte
14.4
42
NULL
604.8
58.17
Hanari Carnes
Rua do Paço, 67
Rio de Janeiro
RJ
05454-876
Brazil
HANAR
Hanari Carnes
Rua do Paço, 67
Rio de Janeiro
RJ
05454-876
Brazil
Janet Leverling
10253
United Package
49
Maxilaku
16
40
NULL
640
58.17
Chop-suey Chinese
Hauptstr. 31
Bern
NULL
3012
Switzerland
CHOPS
Chop-suey Chinese
Hauptstr. 29
Bern
NULL
3012
Switzerland
Steven Buchanan
10254
United Package
24
Guaraná Fantástica
3.6
15
0.15000000596046448
45.9
22.98
Chop-suey Chinese
Hauptstr. 31
Bern
NULL
3012
Switzerland
CHOPS
Chop-suey Chinese
Hauptstr. 29
Bern
NULL
3012
Switzerland
Steven Buchanan
10254
United Package
55
Pâté chinois
19.2
21
0.15000000596046448
342.72
22.98
Chop-suey Chinese
Hauptstr. 31
Bern
NULL
3012
Switzerland
CHOPS
Chop-suey Chinese
Hauptstr. 29
Bern
NULL
3012
Switzerland
Steven Buchanan
10254
United Package
74
Longlife Tofu
8
21
NULL
168
22.98
Richter Supermarkt
Starenweg 5
Genève
NULL
1204
Switzerland
RICSU
Richter Supermarkt
Grenzacherweg 237
Genève
NULL
1203
Switzerland
Anne Dodsworth
10255
Federal Shipping
2
Chang
15.2
20
NULL
304
148.33
Richter Supermarkt
Starenweg 5
Genève
NULL
1204
Switzerland
RICSU
Richter Supermarkt
Grenzacherweg 237
Genève
NULL
1203
Switzerland
Anne Dodsworth
10255
Federal Shipping
16
Pavlova
13.9
35
NULL
486.5
148.33
Richter Supermarkt
Starenweg 5
Genève
NULL
1204
Switzerland
RICSU
Richter Supermarkt
Grenzacherweg 237
Genève
NULL
1203
Switzerland
Anne Dodsworth
10255
Federal Shipping
36
Inlagd Sill
15.2
25
NULL
380
148.33
Richter Supermarkt
Starenweg 5
Genève
NULL
1204
Switzerland
RICSU
Richter Supermarkt
Grenzacherweg 237
Genève
NULL
1203
Switzerland
Anne Dodsworth
10255
Federal Shipping
59
Raclette Courdavault
44
30
NULL
1320
148.33
Wellington Importadora
Rua do Mercado, 12
Resende
SP
08737-363
Brazil
WELLI
Wellington Importadora
Rua do Mercado, 12
Resende
SP
08737-363
Brazil
Janet Leverling
10256
United Package
53
Perth Pasties
26.2
15
NULL
393
13.97