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, 1774🔥, 0💬
Popular Posts:
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...