/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 vote161 views1 answer
Sql list all procedures
SQL
3 votes149 views2 answers
Postgres alter table owner
SQL
0 vote124 views1 answer
Sub blocks in sql
SQL
3 votes150 views1 answer
Sql online test questions and answers
SQL
0 vote153 views1 answer
Oracle list user locked
SQL
0 vote131 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote147 views1 answer
Mysql change timestamp on update
SQL
2 votes148 views2 answers
Create empty table from existing table
SQL
0 vote135 views1 answer
Call rest api from postgresql
SQL
0 vote131 views1 answer
Restore backup "text" postgresql command line
SQL