/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 vote180 views1 answer
Round up and down sql
SQL
0 vote177 views2 answers
Sqlite unix timestamp
SQL
0 vote135 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote178 views5 answers
Linq cheat sheet
SQL
0 vote266 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote305 views1 answer
Oracle convert int to date
SQL
0 vote173 views1 answer
Install mysql for fedora 34
SQL
0 vote188 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
0 vote178 views4 answers
Restart MySQL
SQL
4 votes181 views1 answer
Oracle delete last row
SQL