/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 vote147 views1 answer
Print sum of values sql
SQL
0 vote291 views1 answer
Add user mysql wordpress
SQL
0 vote225 views1 answer
Reindexing all tables sql server
SQL
0 vote187 views1 answer
Sql find all different values in column
SQL
0 vote189 views1 answer
Mysql update from n to 100
SQL
0 vote179 views1 answer
Suse status MySQL
SQL
6 votes194 views2 answers
Oracle trigger
SQL
0 vote241 views1 answer
Count database access django
SQL
0 vote176 views2 answers
Insert into
SQL
0 vote176 views1 answer
Gcloud check sql
SQL