Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.
USE [CNTY_GIS] GO /****** Object: Trigger [dbo].[Changes_To_Parcel_History] Script Date: 06/13/2013 14:51:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER TRIGGER [dbo].[Changes_To_Parcel_History] ON [dbo].[Parcel] After UPDATE AS IF UPDATE (Geometry) OR UPDATE(OP_Designation) OR UPDATE(OP_Amendment_No) OR UPDATE(Zone_Name) OR UPDATE(Parcel_ID) OR UPDATE(Roll_Number) OR UPDATE(Zone_Bylaw_No) OR UPDATE(Zone_Schedule_Name) INSERT INTO Parcel_History ([geometry], [OP_Designation], [OP_Amendment_No] ,[Zone_Name],[Parcel_ID], [Roll_Number], [Zone_Bylaw_No],[Zone_Schedule_Name]) SELECT (geometry), (OP_Designation), (OP_Amendment_No) ,(Zone_Name),(Parcel_ID), (Roll_Number), (Zone_Bylaw_No),(Zone_Schedule_Name) FROM inserted set identity_insert Parcel_History OFF
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.