InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 14:25:04 GMT20http://www.sqlservercentral.com/Forums/Topic764993-1291-1.aspxThe problem was with the Delimitator :) now It works... thank u 4 replayMon, 23 Jul 2012 00:13:00 GMTgeidy_killer89http://www.sqlservercentral.com/Forums/Topic764993-1291-1.aspxgeidy_killer: Thread hijacking issues aside, you may find the information you seek in this forum post: [url]http://www.sqlservercentral.com/Forums/Topic1332707-392-1.aspx[/url]Look for answers in it from Kingston and me.Mon, 23 Jul 2012 00:10:05 GMTdwain.chttp://www.sqlservercentral.com/Forums/Topic764993-1291-1.aspx[quote][b]geidy_killer89 (7/13/2012)[/b][hr]my database [sahia] the table [carti] i want to automaticaly change the [datead] field , with the curent date when i insert or update a record. I've tried but did not work[/quote]Welcome to SQL Server Central !!!Please do not post your problems in other threads.Create a new thread of your own and post the code of the trigger you are using along with some explanation of what you are trying to do.Mon, 16 Jul 2012 02:18:53 GMTKingston Dhasianhttp://www.sqlservercentral.com/Forums/Topic764993-1291-1.aspxmy database [sahia] the table [carti] i want to automaticaly change the [datead] field , with the curent date when i insert or update a record. I've tried but did not workFri, 13 Jul 2012 22:12:23 GMTgeidy_killer89http://www.sqlservercentral.com/Forums/Topic764993-1291-1.aspxVery neat! Thanks.Tue, 04 Aug 2009 12:08:26 GMTAFIFMhttp://www.sqlservercentral.com/Forums/Topic764993-1291-1.aspxheres a generic example; if you post your actual table definition, we could tailor the example to your actual table:[code]Create Trigger TableName_Update On TableName For Update AsUpdate Tb Set tb.date_modified = GetDate() From TableName Tb Join Inserted i on Tb.PKColumn = i.PKColumn[/code]Tue, 04 Aug 2009 10:48:05 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic764993-1291-1.aspxI am working on a project that will require the transfer of thousands of records from one DB to another. I need to add a new column (LastModified) (Date/Time) to capture the last time a record was modified so I can go back and reconcile the data. Assistance with a trigger to do that is much appreciated.Best,Tue, 04 Aug 2009 10:43:54 GMTAFIFM