/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

-1 vote208 views1 answer
Default username and password for oracle 11g
SQL
0 vote189 views1 answer
Sqlalchemy query sql compiled
SQL
6 votes210 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote202 views1 answer
Create column that already exists mysql
SQL
0 vote193 views1 answer
Sql string length postgresql
SQL
0 vote223 views1 answer
How to print sql query
SQL
1 vote185 views1 answer
Sql Split string function
SQL
3 votes204 views1 answer
Oracle undo tablespace list by user
SQL
0 vote244 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
0 vote223 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL