Adding Address Records into AdventureWorksLT in SQL Server

Q

How to add an address record into AdventureWorksLT in SQL Server?

✍: FYIcenter.com

A

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

 

Installing Sample Scripts and Databases in SQL Server

⇒⇒SQL Server Database Tutorials

2016-12-02, 216👍, 0💬