/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 vote216 views1 answer
Postgresql interview questions
SQL
15 votes210 views6 answers
Psql
SQL
4 votes199 views1 answer
Create table if not exist in sqlite
SQL
20 votes196 views1 answer
Sql change column types
SQL
0 vote201 views1 answer
Fill up postgres db
SQL
1 vote223 views3 answers
Sql union
SQL
0 vote234 views2 answers
Greater than sql server
SQL
10 votes223 views5 answers
Create table mysql query
SQL
0 vote198 views1 answer
How to use query in nosql
SQL
0 vote202 views1 answer
Sql convert datetime to year
SQL