/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 vote368 views1 answer
Sql server epoch to datetime
SQL
0 vote373 views1 answer
How to check event scheduler status mysql
SQL
0 vote399 views2 answers
Execute stored procedure without db set
SQL
4 votes366 views4 answers
Pl sql output
SQL
0 vote364 views1 answer
Get enginge db mysql
SQL
0 vote400 views1 answer
Add user mysql wordpress
SQL
1 vote385 views2 answers
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.4.0 or newer is required; you have 0.10.1.
SQL
1 vote538 views1 answer
Postgres upgrade to superuser
SQL
1 vote352 views1 answer
Oracle split string
SQL
1 vote334 views2 answers
Mysql SELECT
SQL