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
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