SQL 2000创建插入触发器

向ComponentTable插入数据时,将drawingId 和hardwareId插入到表HardWareTable

CREATE TRIGGER InsertComponentTable
on ComponentTable
FOR INSERT
AS
begin
  declare @tempDrawingId varchar(50), @tempHardwareId varchar(25)
  select @tempDrawingId=drawingId from inserted
  select @tempHardwareId=hardwareId from inserted
  insert into HardWareTable (hardwareId,drawingId) values (@tempHardwareId,@tempDrawingId);
end
Go