/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

3 votes170 views2 answers
Oracle apex charging debug
SQL
1 vote163 views2 answers
String to date postgres
SQL
0 vote202 views1 answer
Postgresql create table default value timestamp
SQL
6 votes175 views2 answers
Psql load dump
SQL
0 vote167 views1 answer
Bigquery declare
SQL
1 vote160 views1 answer
Substr sql last character
SQL
0 vote223 views1 answer
Dockerfile example for Django
SQL
0 vote174 views1 answer
Postgres sequence name
SQL
0 vote170 views1 answer
Mysql query problems and solutions
SQL
1 vote171 views1 answer
Ef core 5.0 usesqlserver not found
SQL