At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!
When i have this Trigger enabled my table record will not update. I have tried 2 different front end GIS Softwares both with the same result. Nothing.
ALTER TRIGGER [dbo] [FName_AName_Num_Lastdate_Cont_Segment] ON [dbo].[Segment] AFTER INSERT, UPDATE AS BEGIN SET NOCOUNT ON; UPDATE Segment SET Street_Full_Name = st.Street_Full_Name, AnnoName = st.AnnoName FROM dbo.Segment s INNER JOIN INSERTED i ON s.OID = i.OID INNER JOIN dbo.Street st ON s.Street_ID = st.Street_ID END
ALTER TRIGGER [dbo].[Changes_Segment] ON [dbo].[Segment] FOR UPDATE AS IF UPDATE(L_F_ADD) OR UPDATE(L_T_ADD) OR UPDATE(R_T_ADD)OR UPDATE(R_F_ADD) OR UPDATE(ROADJUR) INSERT INTO dbo.Segment_History SELECT * FROM inserted
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.