选种Eexcep右键点所有任务有管理触发器,
CREATE TRIGGER aaa ON dbo.[Eexcep]
FOR INSERT
AS
DECLARE @L1,@L2,@L3....SELECT @L1 =你要的列名,@L2= 你要的列名,@3.... from inserted
insert into emonth
values(@L1,@L2,@L3,...)
CREATE TRIGGER aaa ON dbo.[Eexcep]
FOR INSERT
AS
DECLARE @L1,@L2,@L3....SELECT @L1 =你要的列名,@L2= 你要的列名,@3.... from inserted
insert into emonth
values(@L1,@L2,@L3,...)
我用sql server也不 久,不足之处还望指教,但不明白好象我这样做没什么问题啊?