/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 vote153 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
0 vote143 views1 answer
Grant privileges mysql to database 1064
SQL
4 votes133 views1 answer
Mysql copy table with new name
SQL
0 vote131 views1 answer
Mysql set column equal to another automatic
SQL
33 votes139 views6 answers
Sql delete
SQL
0 vote132 views1 answer
SQL column name Oracle
SQL
0 vote151 views1 answer
Add mysql database to power bi web
SQL
3 votes218 views2 answers
Savepoint in sql
SQL
-1 vote137 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
10 votes149 views1 answer
All_dependencies
SQL