database trigger

[cfpaperboy]

Have a table of registered users, I'll call it "users." It has fields email,
username, password and accesslevel.

When a user registers on our site, I would like a database entry entered into
the "user" table, but also a new record should be inserted into my blog
software user table, and possibly other tables, but for the sake of simplicity
I'll keep it to one and assume I can repeat the process for each table.

Can anyone share with me how to write this code in SQL Enterprise Manager? I
would also want this to change the child entry in the child table whenever a
record in the "user" table was updated or deleted.

[paross1]

Right out of SQL Server BOL.....


Phil

CREATE TRIGGER
Creates a trigger, which is a special kind of stored procedure that executes
automatically when a user attempts the specified data-modification statement
on the specified table. Microsoft? SQL Server allows the creation of multiple
triggers for any given INSERT, UPDATE, or DELETE statement.

Syntax
CREATE TRIGGER trigger_name
ON { table | view }
[ WITH ENCRYPTION ]
{
{ { FOR | AFTER | INSTEAD OF } { [ INSERT ] [ , ] [ UPDATE ] }
[ 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 ]
}
}