/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

5 votes298 views4 answers
Traduction
SQL
0 vote283 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote284 views2 answers
Add new column after in sql
SQL
0 vote281 views1 answer
Sql select upcoming birthdays
SQL
7 votes270 views2 answers
Add column table pl sql
SQL
1 vote297 views1 answer
Update from table tsql
SQL
0 vote325 views1 answer
How to find unique element in sql
SQL
0 vote251 views1 answer
Ms sql unique
SQL
0 vote297 views1 answer
Define a variable in mysql from select
SQL
0 vote255 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL