/SQL/SQL Server modify_timestamp trigger

SQL Server modify_timestamp trigger

CREATE TRIGGER dbo.updateDate
ON dbo.test
AFTER INSERT, UPDATE 
AS UPDATE test SET test = CURRENT_TIMESTAMP
      FROM test t
	    INNER JOIN inserted i
		  ON t.ID = i.ID
GO

Source: social.msdn.microsoft.com

Similar codes

-1 vote346 views2 answers
Postgresql get last 10 records
SQL
0 vote343 views1 answer
Sql count * vs count 1
SQL
0 vote335 views1 answer
T-SQL Never ending DELETE
SQL
1 vote283 views1 answer
Mysql see column types
SQL
0 vote348 views1 answer
Check connections to database postgres
SQL
0 vote366 views2 answers
Connect to mysql server mac terminal
SQL
0 vote307 views1 answer
Postgresql copy backup table
SQL
5 votes368 views4 answers
Mysql update column with value from another table
SQL
0 vote391 views1 answer
Sql query inline if
SQL
0 vote309 views1 answer
Update set with join pl sql
SQL