Transact SQL 101 - Lesson 06_03_SQL.txt

--DELETE (Example 1)
DELETE FROM saleslt.customeraddress
WHERE addressid IN (569,589)

--DELETE (Example 2)
DELETE saleslt.address
WHERE city = 'Round Rock'

--DELETE (Example 3)
DELETE FROM saleslt.customeraddress
WHERE	addressid IN (
		SELECT addressid 
		FROM saleslt.address 
		WHERE city = 'Garland')
		
		
		USE adventureworksLT
GO

INSERT INTO saleslt.customeraddress VALUES (75,567,'Main Office', DEFAULT, GETDATE())
INSERT INTO saleslt.customeraddress VALUES (166,578,'Main Office', DEFAULT, GETDATE())

--Original Address ID = 569
INSERT INTO saleslt.address VALUES ('Sapp Road West',NULL,'Round Rock','Texas','United States','78664',DEFAULT,GETDATE())
SELECT * FROM saleslt.address 
INSERT INTO saleslt.customeraddress VALUES (93,11384,'Main Office', DEFAULT, GETDATE())

--Original Address ID = 589
INSERT INTO saleslt.address VALUES ('One Dancing, Rr No. 25','Box 8033','Round Rock','Texas','United States','78664',DEFAULT,GETDATE())
SELECT * FROM saleslt.address 
INSERT INTO saleslt.customeraddress VALUES (273,11385,'Main Office', DEFAULT, GETDATE())