/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 vote264 views1 answer
Sql developer connect to sql server
SQL
9 votes258 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote233 views1 answer
What are the aggregate function in sql
SQL
0 vote256 views1 answer
Mysql cast null to string
SQL
0 vote261 views1 answer
Geopoint from json mysql function
SQL
2 votes241 views2 answers
Oracle multiple insert
SQL
0 vote269 views1 answer
Store case result sql
SQL
0 vote270 views1 answer
Mysql workbench format date
SQL
0 vote260 views1 answer
Get number of rows in every table mysql
SQL
0 vote244 views1 answer
Check mysql password with docker container magento 2
SQL