create trigger trigname on server
for insert
as
Insert into Send(ServerID,GameID,..)
select a.ServerID,b.FactionID,..
from Inserted a inner Join Faction b
on a.ServerID=b.FactionID
gocreate trigger trigname on Faction
for insert
as
Insert into Send(ServerID,GameID,..)
select b.ServerID,a.FactionID,..
from Inserted b inner Join Server a
on a.ServerID=b.FactionID
go
for insert
as
Insert into Send(ServerID,GameID,..)
select a.ServerID,b.FactionID,..
from Inserted a inner Join Faction b
on a.ServerID=b.FactionID
gocreate trigger trigname on Faction
for insert
as
Insert into Send(ServerID,GameID,..)
select b.ServerID,a.FactionID,..
from Inserted b inner Join Server a
on a.ServerID=b.FactionID
go
on server
for insert
as
declare @factionid int
declare @serverid int
select @factionid = a.factionid
from faction as a
where a.gameid = (select b.gameid from inserted as b)
select @serverid = serverid from inserted
insert into send(serverID,FactionID)
values(@serverid,@factionid)