建立触发器后,插入操作提示必须为Identity项提供数据
如何处理,其中Record_tab
包含RecordId(Identity)RecordDateTime,RecordPeople,ServiceType四项
----------------------------------------------
--代理人记录本视图的插入操作
CREATE TRIGGER [TriggerForCRS_View_Insert] ON [dbo].[CRS_view]
INSTEAD OF INSERT
AS
BEGIN
INSERT INTO dbo.Record_tab--对基本记录信息表的操作
SELECT RecordDateTime,RecordPeople,ServiceType
From inserted
IF((SELECT ServiceType FROM inserted)='故障处理')OR((SELECT ServiceType FROM inserted)='业务支持')
BEGIN
INSERT INTO dbo.BookingCustomer_tab--对客户信息表的操作
SELECT @@IDENTITY,OfficeNumber,OfficeName,Linkman,Telphone,'代理人'
FROM inserted
INSERT INTO dbo.Service_tab--对故障情况表的操作
SELECT @@IDENTITY,Application,Minutia,Description,Solution,HandleSymbol,HandleDateTime,HandlePeople
FROM inserted
IF(SELECT InnerconveySymbol FROM inserted)=1
BEGIN
INSERT INTO dbo.HandleProcess_tab--对处理过程表的操作
SELECT @@IDENTITY,InnerconveySymbol,InnerConveyDateTime,InnerAccepter,0,NULL,NULL,NULL,CustomReplySymbol,CustomReplyDateTime
From inserted
END
END
END
CREATE TRIGGER 名 on 视图
INSTEAD OF INSERT
AS
BEGIN
INSERT 主表 SELECT name1,name2 FROM inserted
insert 从表 (主表id,其他列) select @@IDENTITY,'cc' from inserted
END