/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

0 vote129 views1 answer
Changer un mot de passe mysql
SQL
1 vote139 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
0 vote134 views1 answer
Oracle right characters
SQL
0 vote154 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
7 votes144 views3 answers
Convert ansi sql
SQL
0 vote124 views2 answers
Clear window pl sql
SQL
0 vote130 views1 answer
Sql server udf performance
SQL
0 vote137 views1 answer
Python connect microsoft sql server
SQL
0 vote139 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote123 views3 answers
Joins and views sql
SQL