Top "Adventureworks" questions

A sample SQL database for SQL Server, maintained by Microsoft.

Permissions error when attaching a database: "Cannot access the specified path"

I am running SQL Server 2012 Enterprise Edition. I have downloaded the AdventureWorks 2012 OLTP data files (both .mdf and .ldf). I …

sql sql-server sql-server-2012 adventureworks
Does AdventureWorks db have tutorials / exercises?

I downloaded and installed AdventureWorks db for sql server 2008. Are there any exercises or tutorials for it? I'd like to …

sql sql-server adventureworks
Where to download AdventureWorks2008.msi?

I'd like to install AdventureWorks2008 (I just install SQL Server 2008 R2 Express). Each time I download the recommended version from …

sql-server-2008 adventureworks
Adventure Works Explanation

I've been looking at Microsoft's Adventure Works 2012 database. I'd be very interested if there's any information explaining why the tables …

sql sql-server tsql adventureworks
Where to download this version of adventureworks database

Hi all, I started studying SQL Server from this book SQL Server 2008 Transact-SQL Recipes. My problem is I can't get …

sql-server-2008 adventureworks
Understanding adventureworks2012 db structure

I go through a tutorial on hierachyid and for their explanation they use the following query on the advantureworks2012 Select * …

sql-server adventureworks
In T-SQL how to display columns for given table name?

I am trying to list all of the columns from whichever Adventureworks table I choose. What T-sQL statement or stored …

sql-server tsql exec adventureworks
create hierarchy in non parent child dimensions

I am creating a user hierarchy for product dimension with AdventureWorksDW in a cube. I have added Product Key, ProductCategory …

hierarchy cube class-hierarchy adventureworks