Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Adding Address Records into AdventureWorksLT

By: FYIcenter.com

(Continued from previous topic...)

How to add an address record into AdventureWorksLT?

To find out if we can add data into AdventureWorksLT or not, you can try to add an address record into the "SalesLT.Address" in AdventureWorksLT:

USE AdventureWorksLT
GO

INSERT SalesLT.Address (AddressLine1, City, StateProvince, 
      CountryRegion, PostalCode)
   VALUES('1 Main Street', 'Java', 'Oracle', 
      'FYI', 'Center')
GO

SELECT * FROM SalesLT.Address
   WHERE CountryRegion = 'FYI'
GO
AddressID/AddressLin1/AddressLine2/City/StateProvince
   /CountryRegion/PostalCode/rowguid
   /ModifiedDate

11384/1 Main Street/NULL/Java/Oracle
   /FYI/Center/6073DFAE-9803-4B4F-B60E-D9742C0EED1D
   /2007-05-19 19:24:44.140

1. What Samples and Sample Databases Are Provided by Microsoft?
2. How to download and install SQL Server 2005 Sample Scripts?
3. How to download and install the scaled-down database AdventureWorksLT?
4. How to attach AdventureWorksLT physical files to the server?
5. How AdventureWorksLT tables are related?
6. How to add an address record into AdventureWorksLT?