/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 vote390 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote360 views1 answer
Top frequency in sql server
SQL
0 vote330 views2 answers
Update all linkedserver tables with openquery on db
SQL
0 vote327 views1 answer
Replace null value within column mysql
SQL
0 vote356 views1 answer
SQL Server Enterprise
SQL
0 vote284 views1 answer
Oracle sql replace string in clob
SQL
3 votes407 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
10 votes376 views1 answer
Oracle view dependencies
SQL
1 vote404 views1 answer
Sql first day quarter
SQL
1 vote375 views1 answer
How to use db.execute
SQL