/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 vote262 views3 answers
Select top 10 rows in sql
SQL
7 votes237 views2 answers
What is sql clause
SQL
0 vote226 views1 answer
Install sql server windows 10
SQL
8 votes232 views1 answer
Oracle create datafile
SQL
4 votes245 views2 answers
Oracle unlock account
SQL
5 votes245 views2 answers
Sql constraint check value in list
SQL
0 vote238 views1 answer
Select 1 from orders
SQL
0 vote254 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
1 vote215 views1 answer
Oracle create program if no exists
SQL
0 vote224 views1 answer
Sql server select ignore dupplicates
SQL