/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

13 votes342 views2 answers
Check if value is null mysql
SQL
5 votes389 views2 answers
Functions
SQL
0 vote344 views1 answer
Unique index in mysql
SQL
0 vote359 views1 answer
Windows aggregate functions in postgresql
SQL
0 vote366 views1 answer
Java mysql swing example
SQL
0 vote366 views1 answer
Import sql in postgresql
SQL
0 vote376 views1 answer
Alter table add check constraint oracle
SQL
7 votes371 views1 answer
Sql pagination oracle
SQL
0 vote333 views1 answer
Phpmyadmin mysql conflict
SQL
1 vote359 views1 answer
How to unlock table in mysql
SQL