/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

16 votes198 views2 answers
Mysql date between two dates
SQL
0 vote236 views1 answer
Run docker container with database as rds metabase
SQL
0 vote168 views1 answer
Oracle sql date summer time
SQL
0 vote190 views1 answer
Tsql find the value and count of the item that occurs the most in a column
SQL
0 vote164 views1 answer
Sql orcale i forgot what my name & password was
SQL
18 votes186 views4 answers
Uninstall mysql on ubuntu
SQL
1 vote181 views1 answer
Postgres first_value in gropby
SQL
3 votes165 views2 answers
Oracle for loop
SQL
2 votes180 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
2 votes185 views2 answers
How to add not null constraint in sql
SQL