Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER trg_New_Trigger ON dbo.Table1 FOR INSERT AS UPDATE BEGIN SET NOCOUNT ON; UPDATE dbo.Table1 SET Target_Column = (Select substring(cast(getdate() AS CHAR(11)),10,2) + cast(ID_Field AS CHAR(10)) From inserted) WHERE Table1.RowID IN (SELECT RowID FROM inserted) END GO
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!