/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 vote113 views2 answers
Select limit ms sql
SQL
0 vote135 views2 answers
How to find max and min salary in sql
SQL
0 vote162 views1 answer
Postgres foreign key multiple columns
SQL
8 votes137 views1 answer
Show mysql user table
SQL
-1 vote81 views1 answer
Oracle db list usernames
SQL
0 vote134 views1 answer
Mysql get first 2 characters of string
SQL
1 vote130 views2 answers
Begin transaction in sql
SQL
0 vote143 views1 answer
Mysql utc timestamp
SQL
4 votes163 views1 answer
How to check last gather stats on table in oracle
SQL
1 vote120 views1 answer
Add constraint sql
SQL