triggers in different schemas

I am new to SQL Server.

I have to write a trigger for inserting and updating table in different schema in MS SQL.

Example:

TEMP1 table in one Schema

TEMP2 table in another Schema

开发者_如何学编程How can this be done?

As long the SCHEMAs have the same owner (The AUTHORIZATION bit in CREATE SCHEMA) you'd simply refer to the objects using 2 part names.

See CREATE TRIGGER too

create trigger MyTrigger on Schema1.Table1
for insert
as
set nocount on
insert Schema2.Table2 (...)
select (..) from inserted
go

Not sure I understand the problem completely, but basic syntax would look like this:

create trigger MyTrigger on Schema1.Table1
after insert, update
as
    insert Schema2.Table2 values(1, 'test', ...)

    update Schema3.Table3
    set Name = 'XX'
    where Id = 1
go

You have to create multiple triggers to handle different events on different tables.

Refer to CREATE TRIGGER (Transact-SQL).