MS SQL Server Interview Question:

How to add an address record into AdventureWorksLT?

Submitted by: Administrator

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',
'GGL', 'Center')
GO

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

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

Submitted by: Administrator