One of a set of tools we're offering as a way of saying thank you for being a part of the community.
USE [CNTY_GIS] GO /****** Object: Trigger [dbo].[FName_AName_Num_Lastdate_Cont_Segment] Script Date: 05/23/2013 13:36:55 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Alter TRIGGER [dbo].[Add_500000_toID] ON [dbo].[City_Segment] AFTER INSERT AS BEGIN SET NOCOUNT ON; Update City_Segment SET ENTITY_ID = (s.ENTITY_ID + 500000) FROM dbo.City_Segment s INNER JOIN INSERTED i ON s.ENTITY_ID = i.ENTITY_ID END
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.