Stack Overflow
Stack Overflow

Questions tagged [northwind]

A sample database used with Microsoft SQL Server 2000 and some versions of Microsoft Access.

Used in earlier versions, superseded by the sample database introduced in .

Available from http://northwinddatabase.codeplex.com/ (now broken).

193 questions
26
votes
3 answers

Where can I find the Northwind database for Microsoft SQL Server 2008?

I'm trying to find and create/import the Northwind database to practice my Linq-fu. I cannot find it for the life of me, searching just turns me to this page, which in turn tells me to find it on the official page which isn't…
delete
20
votes
9 answers

Is there a "Northwind" type database available for MySQL?

I need some test data for a MySQL utility that I am creating. Does anybody know where I can find one that has a similiar (if not more) amount of data as Northwind for SQL Server?
Josh Stodola
  • 81,538
  • 47
  • 180
  • 227
15
votes
4 answers

SQL - Subquery in Aggregate Function

I'm using the northwind database to refresh my SQL skills by creating some more or less complex queries. Unfortunately I could not find a solution for my last use case: "Get the sum of the five greatest orders for every category in year 1997." The…
Thomas
  • 232
  • 1
  • 2
  • 8
10
votes
2 answers

T4 for Sharp Architecture/Northwind Problem

I have just downloaded sharparchitecture/Northwind and i'm trying to get crud scaffolding to work. I have changed nothing except adding missing reference to this class library. I try to run ScaffoldingGeneratorCommand.tt and I hit following 3…
PK.
  • 588
  • 1
  • 4
  • 12
7
votes
2 answers

Entity Framework - Saving Changes to Related Objects in Detached State

I'm using the Northwind database as an example for this post where I am having a problem saving detached entities back to the database using the entity framework. I have the following two methods to get me the territories and the regions: static…
Ben
  • 71
  • 1
  • 1
  • 2
5
votes
2 answers

Where can I download the Northwind sample database for SQLite?

After looking at: Where can I download Northwind database for Postgresql? it looks like the best place for Northwind data, outside of the Microsoft itself, is: https://code.google.com/archive/p/northwindextended/downloads to what extent does this…
Thufir
  • 8,216
  • 28
  • 125
  • 273
5
votes
3 answers

Can't attach northwind database to sql server 2008 R2

When I try to I get the following error in SQL Server Management Studio: TITLE: Microsoft SQL Server Management Studio Attach database failed for Server 'AHAKEEM'. (Microsoft.SqlServer.Smo) ADDITIONAL INFORMATION: An exception occurred while…
meds
  • 21,699
  • 37
  • 163
  • 314
4
votes
1 answer

How implement a OData V4 services like official example services?

The example services mean this: http://services.odata.org/V4/Northwind/Northwind.svc/ My question is: Why this service has a ".svc" suffix? As I know, now only two ways can implement odata v4 services on .Net platform, RESTier and WebAPI, see…
ahdung
  • 350
  • 3
  • 13
3
votes
2 answers

how to implement Northwind in Django

I am trying to implement Northwind database model in MySQL using Django-admin for displaying data. Does someone know how to do it "clean" way from original model? Is there any functional implementation to download (models, admin)?
Jazzuell
  • 253
  • 1
  • 2
  • 8
3
votes
1 answer

SQL Comparison query

I am doing practice queries to improve my SQL skills (I'm a beginner) and I ran into this problem that I need help with using the Northwind database. The requested query should: Give the name of employees and the city where they live for employees…
Matt Grace
  • 33
  • 2
3
votes
2 answers

How to Specify a Compound key in Entity Framework Code First

I have a quick question about setting up the mappings between [Order Details], [Products] and [Orders] in the Northwind datbase. [Order Details] has no primary key, and looks like this [Order Details] OrderId (int) ProductId (int) ... So my…
Joe
  • 5,389
  • 7
  • 41
  • 63
3
votes
3 answers

Northwind Database Installation Error: Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure 'U'

I am trying to install the sample Northwind Database from the file Northwind.sql. When I run the script on SQL Server Express Management Studio I get an error message that says: Msg 2812, Level 16, State 62, Line 1 Could not find stored procedure…
Sylva Okolieaboh
  • 119
  • 1
  • 2
  • 8
3
votes
1 answer

Northwind traders unitprice redundancy?

In the northwind traders database unitprice is listed on both the products and [order details] tables. Both tables list different prices for the same product. Is this a redundancy or is there an explanation for this?
Phil
  • 3,568
  • 3
  • 34
  • 40
3
votes
1 answer

ASP.NET Massive - How to create database to display VIEW

Hello guys wanna ask help because I don't understand how to create database that I can use using MASSIVE.CS in ASP.NET MVC 3. Im stuck in figuring out how I can implement this MASSIVE class to my MVC project and how connection string connects in…
Jed
  • 1,664
  • 8
  • 33
  • 65
2
votes
1 answer

loading image from Employees table of Northwind database

Since yesterday, i am trying to load an image from a byte array. I get the byte array from the Employees table of NorthWind database. I read some articles saying that there is an OLE header of size 78 that should be removed before we convert from…
Shomron
  • 451
  • 4
  • 13
1
2 3
…
12 13