General MySQL Oracle SQL Server

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

 

⇒ Getting Started with Transact-SQL Statements in SQL Server

⇐ AdventureWorksLT Entity Relation Diagram in SQL Server

⇑ Installing Sample Scripts and Databases in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-12-02, 2273🔥, 0💬

General MySQL Oracle SQL Server