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?
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)
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
pls tell me the sql sever expression edition2005 in 64bit free download link
and tell how to install that
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,
HI sir
i need the Northwind sample database .mdf and ldf file for SQL Server 2005 where can i find it .pls reply
hi,
how i to delete the triggers from a database in SQL Server 2005. pls reply
@sikha
DREOP TRIGGER triggername;
@sikha
DROP TRIGGER triggername;
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
you are one of the good in SQL Thanks.
Fahad Ansari.
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
dear sir,
i need sample database for transaction database..if u can send it to my email.
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.
You can try out the examples given in SQL Server help file on AdventureWorksDB
how can i install sql server on windows 2007
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!
Hello!!!!!!!!!!!!!!!!!!!!
Just i wnt thanks you for your good website.
thanks………………
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??
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
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
Refer this post and ask us if you have any specific doubt
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
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.
may i include external db file into my bd?