/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 vote326 views1 answer
Mysql select from outside
SQL
20 votes289 views5 answers
Mysql reset auto increment to 1
SQL
0 vote302 views1 answer
Sql decode
SQL
19 votes305 views6 answers
Sql create table
SQL
2 votes320 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
0 vote266 views1 answer
Jooq finding lastest value in table
SQL
0 vote307 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
4 votes252 views1 answer
And or sql order of operations
SQL
0 vote313 views1 answer
Oracle dynamic select into
SQL
0 vote296 views1 answer
Add column not null with default value postgres
SQL