求一条SQL Server存储过程,谢谢!
求一条SQL Server存储过程,谢谢!
日期：2007-11-12 15:03:21 人气：1
CREATE TRIGGER Demo
ON aa --aa是A表
FOR INSERT,UPDATE
AS
DECLARE @OldName VARCHAR(50),@NewName VARCHAR(50)
SELECT @OldName=NAME FROM DELETED
SELECT @NewName=NAME FROM INSERTED
INSERT INTO aaa(OldName,NewName,Date) ---aaa是B表
SE