question

I want to Create trigger on a database that would first check if similar trigger exist,if not it then create it.The For any insertion on any table in the database,it populate the DateCreated and DateModified Columns on that table.My current one is only doing it on one table. here is my code: USE [Issue] GO /****** Object: Trigger [dbo].[Update_DateCreated_DateModified] Script Date: 04/11/2013 09:51:20 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: -- Create date: -- Description: -- ============================================= CREATE TRIGGER [dbo].[Update_DateCreated_DateModified] ON [dbo].[Patient] FOR INSERT AS BEGIN DECLARE @getDateCreated Datetime = GETDATE() DECLARE @getDateModified DATETIME=GETDATE() DECLARE @patient_nin VARCHAR(50) = (SELECT NIN FROM INSERTED i) -- interfering with SELECT statements. SET NOCOUNT ON; -- Insert statements for trigger here UPDATE dbo.Patient SET DateCreated=@getDateCreated,DateModified=@getDateModified END GO After some research i came across a code that loop through tables and print the number of rows. Now i just need to integrate the two codes such that the script loops through all the tables and create the trigger above.Please help set nocount on declare @tablename varchar(90) declare @mycount varchar(90) SELECT @mycount = ' ' SELECT @tablename = ' ' while @tablename IS NOT NULL BEGIN SELECT @tablename = MIN(name) FROM sysobjects WHERE type = 'u' and name > @tablename IF @tablename IS NOT null BEGIN SELECT @mycount = 'select '''+@tablename+''', count(*) from ' + @tablename execute (@mycount) END END