Collections:
Attaching AdventureWorksLT Physical Files to the Server in SQL Server
How to attach AdventureWorksLT physical files to the server in SQL Server?
✍: FYIcenter.com
After installed the sample database AdventureWorksLT, you need to attach it to your SQL server to make it available by follow this tutorial:
EXEC sp_attach_db @dbname=N'AdventureWorksLT', @filename1=N'C:\Program Files\Microsoft SQL Server' +'\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf', @filename2=N'C:\Program Files\Microsoft SQL Server' +'\MSSQL.1\MSSQL\Data\AdventureWorks_Log.ldf' GO USE AdventureWorksLT GO SELECT TOP 10 CustomerID, FirstName, LastName, Phone FROM SalesLT.Customer GO CustomerID FirstName LastName Phone 1 Orlando Gee 245-555-0173 2 Keith Harris 170-555-0127 3 Donna Carreras 279-555-0130 4 Janet Gates 710-555-0173 5 Lucy Harrington 828-555-0186 6 Rosmarie Carroll 244-555-0112 7 Dominic Gash 192-555-0173 10 Kathleen Garza 150-555-0127 11 Katherine Harding 926-555-0159 12 Johnny Caprio 112-555-0191
Looks like the sample database AdventureWorksLT is ready for you play.
⇒ AdventureWorksLT Entity Relation Diagram in SQL Server
⇐ AdventureWorksLT - Downloading and Installing the Sample Database in SQL Server
2016-12-02, 1943🔥, 0💬
Popular Posts:
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...