Session 1 : SQL SERVER – Samples Database Adventure Works for SQL Server 2012 AnandTuesday, January 27, 2015 0 comments

SQL SERVER –  Samples Database Adventure Works for SQL Server 2012

AdventureWorks is a Sample Database shipped with SQL Server and it can be downloaded from CodePlex site. AdventureWorks has replaced Northwind and Pubs from the sample database in SQL Server 2005.The Microsoft team keeps updating the sample database as they release new versions.

For SQL Server 2012 RTM Samples AdventureWorks Database is released:

• AdventureWorks2012 Data File
• AdventureWorks2012 Case Sensitive Data File

You can download either of the datafile and create database using the same. Here is the script which demonstrates how to create sample database in SQL Server 2012.

CREATE DATABASE AdventureWorks2012ON (FILENAME = 'D:\AdventureWorks2012_Data.mdf')FOR ATTACH_REBUILD_LOG ;

Please specify your filepath in the filename variable. Here is the link for additional downloads.