/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 vote97 views1 answer
Deny select insert update delete sql
SQL
0 vote147 views1 answer
T-sql delete view if exists
SQL
0 vote103 views1 answer
Sql composite key
SQL
-1 vote112 views8 answers
Sql to c# linq converter online
SQL
1 vote97 views1 answer
Mysql check if string contains comma separated
SQL
8 votes113 views2 answers
Grant all privileges database postgres to user
SQL
5 votes116 views1 answer
Oracle nls instance
SQL
0 vote147 views1 answer
Regex mongoose
SQL
0 vote171 views1 answer
Check user sql password from command line
SQL
8 votes112 views1 answer
Show mysql user table
SQL