/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 vote311 views1 answer
Top 3 salary in sql
SQL
2 votes275 views1 answer
Username sql
SQL
28 votes294 views4 answers
Show tables mysql
SQL
15 votes335 views3 answers
Mysql update add to existing value
SQL
1 vote281 views2 answers
DROP TABLes regardless of constraints
SQL
7 votes278 views4 answers
How to reset the identity column in sql server
SQL
1 vote308 views1 answer
Wordpress change http to https phpmyadmin
SQL
1 vote307 views1 answer
Postgres set column based on another column
SQL
12 votes286 views5 answers
Sql primary key
SQL
4 votes293 views2 answers
Select first and last row mysql
SQL