Trigger

Existen varias formas, pero a través de query analizer
la sintxis es

CREATE TRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
{ { FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ] [
UPDATE ] [ , ] [ DELETE ] }
[ WITH APPEND ]
[ NOT FOR REPLICATION ]
AS
[ { IF UPDATE ( column )
[ { AND | OR } UPDATE ( column ) ]
[ ...n ]
| IF ( COLUMNS_UPDATED ( ) { bitwise_operator }
updated_bitmask )
{ comparison_operator } column_bitmask
[ ...n ]
} ]
sql_statement [ ...n ]
}
}


Estya información la squé del Books Online

Saludos

en que parte se crea un trigger
me podrian ayudar mandandome un ejemplo sencillo
gracias!!


.