CREATE TABLE TrM (id int ,NAME nvarchar(10)) GO CREATE TABLE TrL (id int ,NAME nvarchar(10),writetime datetime CONSTRAINT DF_TrL_writetime DEFAULT(getdate()))CREATE TRIGGER tr_insert ON TrM FOR INSERT AS BEGININSERT INTO Trl(id,name) SELECT INSERTED.id,INSERTED.NAME FROM INSERTED ENDINSERT INTO TrM SELECT 1,'����'UPDATE TrM SET NAME='�IJ���' SELECT * FROM trM SELECT * FROM trL --id NAME --1 �IJ��� --id NAME writetime --1 ���� 2011-04-23 18:46:58.810
CREATE TABLE TrM (id int ,NAME nvarchar(10)) GO CREATE TABLE TrL (id int ,NAME nvarchar(10),writetime datetime CONSTRAINT DF_TrL_writetime DEFAULT(getdate()))CREATE TRIGGER tr_insert ON TrM FOR INSERT AS BEGININSERT INTO Trl(id,name) SELECT INSERTED.id,INSERTED.NAME FROM INSERTED ENDINSERT INTO TrM SELECT 1,'测试'UPDATE TrM SET NAME='修改测试' SELECT * FROM trM--id NAME --1 修改测试SELECT * FROM trL--id NAME writetime --1 测试 2011-04-23 18:46:58.810
(id int ,NAME nvarchar(10))
GO
CREATE TABLE TrL (id int ,NAME nvarchar(10),writetime datetime CONSTRAINT DF_TrL_writetime DEFAULT(getdate()))CREATE TRIGGER tr_insert ON TrM
FOR INSERT
AS
BEGININSERT INTO Trl(id,name) SELECT INSERTED.id,INSERTED.NAME FROM INSERTED
ENDINSERT INTO TrM SELECT 1,'����'UPDATE TrM SET NAME='�IJ���'
SELECT * FROM trM
SELECT * FROM trL
--id NAME
--1 �IJ���
--id NAME writetime
--1 ���� 2011-04-23 18:46:58.810
CREATE TABLE TrM
(id int ,NAME nvarchar(10))
GO
CREATE TABLE TrL (id int ,NAME nvarchar(10),writetime datetime CONSTRAINT DF_TrL_writetime DEFAULT(getdate()))CREATE TRIGGER tr_insert ON TrM
FOR INSERT
AS
BEGININSERT INTO Trl(id,name) SELECT INSERTED.id,INSERTED.NAME FROM INSERTED
ENDINSERT INTO TrM SELECT 1,'测试'UPDATE TrM SET NAME='修改测试'
SELECT * FROM trM--id NAME
--1 修改测试SELECT * FROM trL--id NAME writetime
--1 测试 2011-04-23 18:46:58.810