/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 vote213 views2 answers
Snowflake alter column data type
SQL
1 vote203 views2 answers
Sql left characters
SQL
6 votes222 views4 answers
Mysql group by month
SQL
1 vote195 views1 answer
Alter table column size oracle
SQL
1 vote206 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
1 vote211 views1 answer
How to check the mysql version mac
SQL
1 vote229 views1 answer
Mysql select all and rename one
SQL
0 vote211 views1 answer
Sql comand for removing data from table
SQL
9 votes226 views3 answers
Mysql run sql file
SQL
0 vote262 views1 answer
Copy row from db to db mysql
SQL