/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 vote268 views1 answer
Insufficient memory to excute the sql query
SQL
1 vote261 views1 answer
Check constraint to check if date greater than todays date
SQL
10 votes277 views4 answers
Inner join in update query mysql
SQL
0 vote266 views1 answer
Mysql select last 15 minutes
SQL
0 vote273 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
27 votes301 views5 answers
Mysql set password for user
SQL
5 votes264 views1 answer
Ascending order and where in sql
SQL
0 vote294 views1 answer
Mysql disable triggers
SQL
8 votes272 views1 answer
Database backup in mysql server recovery
SQL
0 vote263 views2 answers
How to find max and min salary in sql
SQL