CREATE TRIGGER [InsertA] ON [dbo].[A]
FOR INSERT
AS
DECLARE @m_id int
//定义插入数据的参数
SELECT @m_id=id,...FROM Inserted //其他插入数赋值
If exists(SELECT id FROM B where id =@m_id)
begin
set @command='INSERT INTO [dbo].[C]([id]....) VALUES('+''+
''+ CONVERT(nvarchar(10),@m_id) + ''+.....+ ')'
EXECUTE @command
END
else
If exists(SELECT id FROM D where id =@m_id)
begin
set @command='INSERT INTO [dbo].[C]([id]....) VALUES('+''+
''+ CONVERT(nvarchar(10),@m_id) + ''+.....+ ')'
EXECUTE @command
end
GO