/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 vote231 views1 answer
Drop all tables db2
SQL
3 votes219 views1 answer
Oracle function
SQL
-1 vote278 views1 answer
Ms sql select datetime as date
SQL
1 vote239 views1 answer
How to unlock table in mysql
SQL
5 votes265 views1 answer
Oracle drop index if exists
SQL
21 votes230 views6 answers
Docker run mysql
SQL
2 votes236 views2 answers
Oracle no data found error code
SQL
1 vote312 views1 answer
Sql and
SQL
0 vote252 views4 answers
Open mysql port bitnami tomact
SQL
1 vote276 views1 answer
Delete mysql ubuntu 20.04
SQL