Thus far all I have done with SQL are simple select statements, but now I've also started learning about INNER JOINs, GROUP BY clauses and inner queries. I learned the concepts, but now I’d like to do some exercises using the Northwind database, so that such queries would become second nature. I tried to come up with good examples tha...
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? ...
For a XSLT project I could sure use a .xml file that fills the same gap that Northwind fills for database projects. It should be 20-100k, but still have a good amount of data that is easy to recognize. Sorta like Northwind. What do you use? ...
I have installed a sample database, specifically Northwind from http://msdn.microsoft.com/en-us/library/8b6y4c7s.aspx. After installing the .msi file, I dont see any Northwind database in my local sql express server when using SQL Server management studio. Am i missing a step? Do i have to run some script? ...
In this image, why is the EmployeeID pointing to it's own table while the order id is not pointing to the order's table. The screenshot is a picture of the northwind database. ...
As a beginner on NHibernate (2.1.0), I am trying to set up my first unit test using the famous Northwind database. The test goes like this (the configuration files can be found at the end of this question) : ISessionFactory sessionFactory=new Configuration().BuildSessionFactory(); ISession session=sessionFactory.OpenSession(); IList<Cus...
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 List<Region> GetRegions() { using (NorthwindEntities entities = new Northwi...
I have recently downloaded the Access 2007 Northwind example database and would now like to convert the database into a SQL 2005 database. I am using the Developer Edition of SQL 2005 and not SQL Express. I installed the Office 12.0 Access Database Engine OLE DB Provider drivers for working with Access 2007. So far I have 'created' a n...
How can I select query the order/purchase history in northwind database? There are 2 tables(orders and purchase order table) then connected to Inventory Transaction table. ...
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? ...
I've been attempting to walk through the "Creating a Data Access Layer" tutorial found http://www.asp.net/learn/data-access/tutorial-01-cs.aspx I create the DB connection, create the typed dataset and table adapter, specify the sql, etc. When I add the code to the presentation layer (in this case a page called AllProducts.aspx) I am un...
Is there a downloadable Postgres database that contains dummy data? preferably Northwind, something i can practice my query ideas ...
Is there a sample C# winform application (a starter kit or something ) which use the Northwind 2007 Acess Database version ? some concept like http://northwind.codeplex.com/ ? ...
Hi, The following code is generating a runtime error and I have no idea why. from o in Orders group o by o.Employee into employeeOrders select new { employeeOrders.Key.EmployeeID, employeeOrders.Key.FirstName, Orders = from eord in employeeOrders orderby eord.OrderID select new { eord.Or...
Hi, I have two instances of a program that manipulate same Northwind database. When I add some records to the database from one of the instances (for example adding some orders to Orders table with a customer foreign key John), I can query these new records from the other instance of the program properly. The problem begins when I want t...
I need to set up ASP.NET and connect it to some demo (northwind) data. Considering all the versions of SQL, what is the most current /efficient way to get a database into a project and do a select against it? This question arose once we discovered we could download a MDB and a MDF format of northwind... ...