Object type: Trigger

AFTER INSERT trigger inserting Store only if the Customer does not exist in the Individual table.

Summary 

On table:	Delete	Update	Insert	Type
Sales.Store	No	No	Yes	After

Properties 

Modifies data	Transactional	Uses cursors	Executes procedures	Dynamic content	Encrypted
No	Yes	No	No	No	No

Data Source Activity 

Accesses	Description
Sales.Individual	Demographic data about customers that purchase Adventure Works products online.

Applies to

Triggers | Transactional | On insert | After table changes

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation