Select * from Customer

Insert into Customer(CustLastName, CustFirstName,
CustAddress, CustCity, CustState, CustZipcode)
Values('Brown','john','1000 somewhere','Seattle','Wa','908888')

Select * from sys.Tables
Select * from sys.Procedures
Select * from sys.Columns


Alter trigger tr_CustomerDelete on Customer
For delete
--this trigger will execute after the delete
AS
--check to see if our temp table exists
if not exists 
	(Select "Name" From sys.Tables
		Where "Name"='CustDelete')
Begin
--if not create it
Create Table CustDelete
(
  CustID int,
  CustLastName varchar(30),
  CustFirstName varchar(25),
  CustAddress varchar(100),
  CustCity varchar(50),
  CustState char(2),
  CustzipCode char(11),
  CustPhone char(10)
)

End

--insert the deleted values into the temp table
Insert into CustDelete (CustID, custLastName, CustfirstName,
			CustAddress, CustCity, CustState, CustZipCode, CustPhone)
	(Select CustID, CustLastName, custFirstname, CustAddress, CustCity,
		CustState, CustZipcode, custphone From Deleted)



Delete from Customer
Where CustID=14

Select * from CustDelete


Create trigger tr_magDelete on Magazine
Instead of delete
As
print 'you cant delete a magazine'

Delete from Magazine where Magid=3

Drop trigger tr_magDelete

Select * from Magazine