MSSQL 2000 trigger on update [modified]

[Ronni Marker]

Hi Guys, Havent been working much on triggers and well have to get one to work now, so need some help to get the holy grail. I have a table called username and when ever a record have been changed I need to update the last update time in column lastvisittime. The problem is that with this trigger below it updates every record in the table and not just the single one that is being updated. CREATE TRIGGER [TimeUpdate] ON [dbo].[username] FOR UPDATE AS UPDATE username set lastvisittime = dbo.TINT(getdate()) Generally I need to know how do I find out what row was currently supposed to be updated? Isteadof updating the whole table as it does now. Have been trying good old uncle google but didnt find any clue to it, so hope the experts here can help :) N.b. dbo.TINT(getdate()) is just a function that changes the datetime to an int value. Cheers, Ronni

modified on Saturday, April 5, 2008 6:57 AM

[Ronni Marker]

Okay found out myself. CREATE TRIGGER [TimeUpdate] ON [dbo].[username] FOR UPDATE AS DECLARE @ID int Select @ID = id from inserted UPDATE username set lastvisittime = dbo.TINT(getdate()) where id = @ID