/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 vote145 views1 answer
Mysqldump ignore table
SQL
2 votes162 views1 answer
Oracle percentage
SQL
0 vote151 views1 answer
Mariadb mysql root access denied
SQL
8 votes168 views1 answer
Database backup in mysql server recovery
SQL
1 vote162 views2 answers
Find nth highest salary of an employee
SQL
0 vote162 views1 answer
How to update date value in sql
SQL
0 vote149 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
5 votes151 views2 answers
Ranking functions in sql
SQL
0 vote154 views1 answer
T sql return on letters only
SQL
0 vote140 views1 answer
Soql more than today
SQL