SQL SERVER – NorthWind Database or AdventureWorks Database – Samples Databases

SQL SERVER - NorthWind Database or AdventureWorks Database - Samples Databases Northwind_diagram-800x594 SQL Server 2005 does not install sample databases by default due to security reasons.I have received many questions regarding where is sample database in SQL Server 2005. One can install it afterward. AdventureWorks and AdvetureWorksDS are the new sample databases for SQL Server 2005, they can be download from here. Let us learn how to install NorthWind Database – samples databases.

After installing sample databases the second most asked question is WHERE IS NORTHWIND?

Solarwinds

Northwind database was the best sample database for SQL Server 2000. Since I started to work with AdventureWorks of SQL Server 2005, I like AdventureWorks as much as Northwind. Northwind is not the best database due to few new features of analysis and reporting service of SQL Server 2005. MSDN Book On Line (BOL) uses the AdventureWorks in all of their examples and it makes it easy to follow up if a proper understanding of AdventureWorks schema is developed. However, SQL Server Compact Edition uses Northwind as a sample database.

If you still want to download and install Northwind and Pubs in SQL Server 2005, download them from here.

My recommendation: Start getting familiar with AdventureWorks.
UPDATE: SQL SERVER – 2005 NorthWind Database or AdventureWorks Database – Samples Databases – Part 2 explains how to restored NorthWind to SQL Server 2000 using images.

Reference : Pinal Dave (https://blog.sqlauthority.com)

Solarwinds
, , ,
Previous Post
SQL SERVER – 2005 Explanation Left Semi Join Showplan Operator and Other Operator
Next Post
SQL SERVER – 2005 Retrieve Configuration of Server

Related Posts

70 Comments. Leave new

  • sir,
    why we are using adventureworks,go in sql queries in sql 2005.but already we are using quries without “Go and AdventureWorks”.
    Please tell me the Reason sir
    Thanks

    Reply
  • pls tell me the sql sever expression edition2005 in 64bit free download link
    and tell how to install that

    Reply
  • Sir I have most perfusion of complexity with adventureworks. Plenty times sql experience and most plentiful my knowledge. Much much problem task take away good and timely running of the service not knowing how this can be,

    Reply
  • HI sir

    i need the Northwind sample database .mdf and ldf file for SQL Server 2005 where can i find it .pls reply

    Reply
  • hi,

    how i to delete the triggers from a database in SQL Server 2005. pls reply

    Reply
  • islam elkhadawey
    June 30, 2010 9:13 pm

    my ( sample soft database.mdf ) is lost and i don’t know what i can do to recover it please help me. sql server-2005

    Reply
  • you are one of the good in SQL Thanks.
    Fahad Ansari.

    Reply
  • Hi dave:
    I am new to SQL Server. I have successfully installed .Net Framework 3.5.1, SQL Server 2008 developer version (on Windows Vista Home edition) and AdventureWork sample database per your suggestions on your web site. But I just can’t see the diagrams. When I click at the DB on the left side, windows on the right side is Blank instead of showing the diagrams of each table.
    What did I do wrong? or do I need more new SW missing?…. If so, please give me links for download. Any help it will be greatly appreciate!!!
    Thanks!!!
    Hung

    Reply
  • dear sir,
    i need sample database for transaction database..if u can send it to my email.

    Reply
  • Sir ,i want to know that what is use of sample database. i installed AdventureWorksDB .how is it use for project/application
    plz send mail for it.

    Reply
  • how can i install sql server on windows 2007

    Reply
  • Good day Sir

    I’ve just started familiarising myself with SQL and programming in general again. I’ve installed SQL Server 2005 Express successfully and downloaded the AdventureWorks sample database. I’m sure you aware that the database cannot be attached using the Control Panel/Program Features in Windows 7 as there is no option to add to the current SQL 2005 Express installation. How else can I add the DB, is there a script I can run perhaps?

    Thanks!

    Reply
  • Hello!!!!!!!!!!!!!!!!!!!!
    Just i wnt thanks you for your good website.
    thanks………………

    Reply
  • Well when i tried connecting to adventure works database from visual studio 2008, i get many errors on the web browser, but when i connect to northwind or pubs database i get the orignal database on the browser, why does it happen with adventureworks??

    Reply
  • AUD CHF DKK EUR
    AUD 1.3691 1 1.10634 0.18393 1.3691

    i want to calculate
    aud / aud (=1.3691000000/1.3691000000) = 1
    aud / chf (=1.3691000000/ 1.2375000000) = 1.106343434
    aud / dkk (=1.3691000000/ 7.4432) = 0.183939703
    aud / eur (=1.3691000000/ 1) = 1.3691

    AUD CHF DKK EUR
    CHF 1.2375 0.90387 1 0.16625 1.2375
    likewise
    chf / chf (= 1.2375000000 / 1.2375000000 )= 1
    chf / aud (= 1.2375000000 / 1.3691000000 )= 0.90387
    chf / dkk (= 1.2375000000 /7.4432 ) = 0.16625
    chf / dkk (= 1.2375000000 /1 ) = 1.2375

    AUD CHF DKK EUR
    DKK 7.4432 5.43656 6.01470 1 7.4432
    so..on

    AUD CHF DKK EUR
    EUR 1 0.73040 0.80808 0.13435 1

    My query is
    SELECT
    DISTINCT
    Curncy_Info_Cur.Currency AS Curncy,
    Curncy_Info_Rate.Spot_Rate AS Spot_Rate
    FROM
    Curncy_Info AS Curncy_Info_Cur
    LEFT OUTER JOIN Curncy_Info AS Curncy_Info_Rate ON Curncy_Info_Cur.Currency=Curncy_Info_Rate.Currency
    AND Curncy_Info_Rate.Period=(SELECT Net_Status.Netting_Period FROM Net_Status WHERE Net_Status.Netting_Status=’1′ AND Net_Status.Phase=’netting’ )
    ORDER BY Curncy_Info_Cur.Currency

    gives output below

    AUD 1.3691
    CHF 1.2375
    DKK 7.4432
    EUR 1
    GBP 0.867
    JPY 103.896
    MXN 18.0583
    NZD 1.74431
    PLN 4.328
    THB 41.91
    USD 1.3563
    ZAR 0

    Reply
  • hello pls can you help me regarding the post above as i am stuck and not able to do crosstab query or pivot

    thanx in advance

    Reply
  • Abhishek Kashyap
    February 7, 2013 9:24 pm

    Dear all members
    Regards to all
    I am new to SQL server Infact I am more in writting code for C#, asp.net but sql was never my cup of tea. But I feel database is like a backbone for a developer so please guide me how can I be good in t-sql, in complex queries.

    Thanks & Regards

    Reply
  • Hello Pinal,

    I have installed the AdventureWorks database in SQL Server 2005 perfectly. However the problem is that everytime I want to fire a query, I have to type the full schema name and the table name, case-sensitively from which I have to retrieve the results. So for example if I want tor retrieve all the rows from Employee table, I have to type,

    select *
    from HumanResources.Employee

    If instead of the above I fire the following query,

    select *
    from Employee

    or

    select *
    from employee

    or

    select *
    from humanresources.employee

    the server returns an exception saying that object name is not found.

    Do you know where can I download the case-insensitive AdventureWorks database or how can I modify the existing AdventureWorks database in such a way that I will not require to type the database-name or schema-name everytime or case-sensitive characters for the database-name or schema-name or table-name, while firing a query?

    Reply at the earliest will be highly appreciated. Thanking you in advance.

    Reply
  • may i include external db file into my bd?

    Reply

Leave a Reply

Menu