Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 AdventureWorks

Author  Topic 

sz1
Aged Yak Warrior

555 Posts

Posted - 2012-03-23 : 05:55:13
Hey

Can anyone give me a good site for the AW database examples?
I want to go thru loads of scenarios covering all sorts of topics querying the DB.
Thanks
S

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2012-03-23 : 06:10:37
http://msdn.microsoft.com/en-us/library/ms124501(v=sql.100).aspx


elsasoft.org
Go to Top of Page

sz1
Aged Yak Warrior

555 Posts

Posted - 2012-03-23 : 06:39:23
well thanks, think there is a whole debate tutorial on practice with this DB.

Think I'm going nuts tho on looking at the AW DB, I dont see a link between the Person.Contact table and the Person.ContactType table? to pull in the contact type name...
Go to Top of Page

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2012-03-23 : 10:15:15
you can click around in here to quickly see what tables are linked together.

http://elsasoft.org/samples/sqlserver_adventureworks/AdventureWorks.htm

Looks like Contact is referred to by these tables via foreign keys:

Employee
VendorContact
ContactCreditCard
Individual
SalesOrderHeader
StoreContact

see "foreign key graph" on this page:

http://elsasoft.org/samples/sqlserver_adventureworks/SqlServer.SPRING.KATMAI.AdventureWorks/table_PersonContact.htm




elsasoft.org
Go to Top of Page
   

- Advertisement -