Last Modified

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Newbies » Last Modified

Last Modified

Rate Topic

Display Mode

Topic Options

Author

Message

AFIFM

Posted Tuesday, August 04, 2009 10:43 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, February 16, 2011 8:25 AM
Points: 24, Visits: 54

I 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,

Post #764993

Lowell

Posted Tuesday, August 04, 2009 10:48 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 11,605, Visits: 27,645

heres a generic example; if you post your actual table definition, we could tailor the example to your actual table:

Create Trigger TableName_Update On TableName For Update As
Update Tb
    Set tb.date_modified = GetDate()
    From TableName Tb
    Join Inserted i on Tb.PKColumn = i.PKColumn

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #764997

AFIFM

Posted Tuesday, August 04, 2009 12:08 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, February 16, 2011 8:25 AM
Points: 24, Visits: 54

Very neat! Thanks.

Post #765055

geidy_killer89

Posted Friday, July 13, 2012 10:12 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, July 23, 2012 12:11 AM
Points: 2, Visits: 3

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

Post #1329726

Kingston Dhasian

Posted Monday, July 16, 2012 2:18 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 4:40 AM
Points: 2,198, Visits: 4,148

geidy_killer89 (7/13/2012)

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

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.

Kingston Dhasian

How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/

Post #1329977

dwain.c

Posted Monday, July 23, 2012 12:10 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:42 AM
Points: 2,338, Visits: 3,158

geidy_killer: Thread hijacking issues aside, you may find the information you seek in this forum post: http://www.sqlservercentral.com/Forums/Topic1332707-392-1.aspx

Look for answers in it from Kingston and me.

No loops! No CURSORs! No RBAR! Hoo-uh!

INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?

Need to UNPIVOT? Why not CROSS APPLY VALUES instead?
Since random numbers are too important to be left to chance, let's generate some!
Are you too recursively challenged?
Splitting strings based on patterns can be fast!

Post #1333605

geidy_killer89

Posted Monday, July 23, 2012 12:13 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, July 23, 2012 12:11 AM
Points: 2, Visits: 3

The problem was with the Delimitator :) now It works... thank u 4 replay

Post #1333607

« Prev Topic | Next Topic »

Permissions