找不出原因,那位遇到过类似的问题没有呀!
相应的代码:
INSERT INTO Node_TroubleClass_Table (Record_Id,Record_Date,Operation_Type_Id,TroubleClass_Id,Restore_Result_Id,Area_Zone_Port,Area_Zone_Port_JiJia)
Select a.Record_Id,a.Record_Date,a.Operation_Type_Id,b.TroubleClass_Id,a.Restore_Result_Id,Area_Zone_Port=case when charindex('-',a.DataPort_Number)>0 then Substring(a.DataPort_Number,1,charindex('-',a.DataPort_Number)) else a.DataPort_Number end,Area_Zone_Port_JiJia = case when charindex('-S',a.DataPort_Number)>0 then Substring(a.DataPort_Number,1,charindex('-S',a.DataPort_Number)) else a.DataPort_Number end
From INSERTED as a join TroubleClass_RestoreClass_Table as b on a.Restore_Result_Id = b.Restore_Result_Id
单独测试是没问题的。。。。。。。。。。。。。。。
IF EXISTS (SELECT name From sysobjects WHERE name = 'Update_OFOPTD_Statistics_Table' AND TYPE = 'TR')
drop TRIGGER Update_OFOPTD_Statistics_Table
GO
CREATE TRIGGER Update_OFOPTD_Statistics_Table
ON Trouble_Record_Table
FOR Update
AS
INSERT INTO OFOPTD_Statistics_Table (Record_Date,Operation_Type_Id,Office_Name,Trouble_Name,Restore_Result_Name,Complaint_sum)
Select Record_Date,Operation_Type_Id,Office_Name,Trouble_Name,Restore_Result_Name,count(*)
FROM INSERTED GROUP BY Record_Date,Operation_Type_Id,Office_Name,Trouble_Name,Restore_Result_Name
ORDER By Record_Date
/******************** CREATE Update_Node_TroubleClass_Table Trigger ****************/
IF EXISTS (SELECT name From sysobjects where name = 'Update_Node_TroubleClass_Table' and type = 'TR')
Drop Trigger Update_Node_TroubleClass_Table
GO
CREATE TRIGGER Update_Node_TroubleClass_Table
ON Trouble_Record_Table
FOR Update
AS
INSERT INTO Node_TroubleClass_Table (Record_Id,Record_Date,Operation_Type_Id,TroubleClass_Id,Restore_Result_Id,Area_Zone_Port,Area_Zone_Port_JiJia)
Select a.Record_Id,a.Record_Date,a.Operation_Type_Id,b.TroubleClass_Id,a.Restore_Result_Id,Area_Zone_Port=case when charindex('-',a.DataPort_Number)>0 then Substring(a.DataPort_Number,1,charindex('-',a.DataPort_Number)) else a.DataPort_Number end,Area_Zone_Port_JiJia = case when charindex('-S',a.DataPort_Number)>0 then Substring(a.DataPort_Number,1,charindex('-S',a.DataPort_Number)) else a.DataPort_Number end
From INSERTED as a join TroubleClass_RestoreClass_Table as b on a.Restore_Result_Id = b.Restore_Result_Id