|
Column |
Format |
Unique value |
Contents |
|---|---|---|---|
|
Id |
Smallint |
|
Store ID. |
|
Name |
Varchar(40) |
|
Store name. |
|
LocationId |
Smallint |
|
Warehouse ID (if different than Store ID). |
Example data
Query
SQL
SELECT TOP 10 *
FROM dbo.Stores
Result
|
Id |
Name |
LocationId |
|---|---|---|
|
1 |
Myymälä 1 |
1 |
|
2 |
Myymälä 2 |
2 |
|
90 |
Varasto |
90 |
|
91 |
Messumyymälä |
91 |
|
92 |
Varastomyymälä |
92 |
|
3 |
Myymälä 3 |
3 |