⟩ 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',
'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