/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

2 votes331 views2 answers
Mysql on duplicate key ignore
SQL
0 vote329 views1 answer
Find largest table in mysql database
SQL
2 votes327 views1 answer
Apex execute batch job
SQL
0 vote337 views1 answer
Oracle running queries sql
SQL
0 vote325 views1 answer
Sql create table with references not primary key
SQL
0 vote340 views1 answer
Mysql start of today
SQL
3 votes366 views1 answer
Sql print all names that start with a given letter
SQL
1 vote353 views1 answer
Sql server list locks
SQL
0 vote338 views1 answer
Create dump file mysql workbench
SQL
-1 vote333 views3 answers
Mysql get age from date
SQL