Answers

Question and Answer:

  Home  MS SQL Server

⟩ 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

 129 views

More Questions for you: