/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 vote198 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
1 vote187 views2 answers
Find a column in all tables mysql
SQL
0 vote189 views1 answer
Php delete database
SQL
0 vote202 views1 answer
Uncheck constraints and delete from table
SQL
-1 vote206 views1 answer
Mysql select count if contains
SQL
0 vote209 views1 answer
Function plsql
SQL
0 vote184 views1 answer
Django how to get query result count
SQL
0 vote229 views1 answer
Basic structure of sql expression having clause
SQL
3 votes202 views4 answers
Truncate syntax in sql
SQL
0 vote209 views1 answer
Date 3 months from today sql
SQL