/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

10 votes212 views4 answers
Else if mysql
SQL
0 vote222 views1 answer
Mariadb disable foreign key checks
SQL
0 vote258 views1 answer
Shortcut run sql pgadmin
SQL
0 vote172 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
1 vote188 views1 answer
Sql find column name like
SQL
2 votes216 views1 answer
Sql compare strings
SQL
0 vote181 views1 answer
Nosql vs sql
SQL
0 vote176 views1 answer
How to see password mysql vestacp
SQL
1 vote170 views1 answer
Mysql select row max date
SQL
0 vote201 views2 answers
While mysql
SQL