/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 vote253 views1 answer
Show all mongodb
SQL
6 votes267 views4 answers
Delete table sqlite
SQL
0 vote274 views1 answer
Insert data from stored procedure into table
SQL
3 votes253 views1 answer
Show index table
SQL
7 votes262 views1 answer
Connect mysql docker
SQL
1 vote245 views1 answer
Postgres get timestamp
SQL
5 votes249 views3 answers
Mysql check if null or empty string
SQL
0 vote262 views1 answer
Sql remove non numeric characters
SQL
0 vote283 views1 answer
How to locate pg_hba.conf file
SQL
0 vote269 views1 answer
Oracle shrink table
SQL