Sql

Search

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: load data from text file to mysql database on mac terminal
Sql :: no suitable driver found for sqlite
Sql :: mysql check all tables
Sql :: sql server fn_dblog
Sql :: reset counter postgres
Sql :: postgres show table schema
Sql :: collation in sql
Sql :: sql contains vs like
Sql :: limit and offset in stored procedure mssql
Sql :: compression of dabatase mysqldumo
Sql :: cql insert
Sql :: cascade syntax in sql
Sql :: sql alias
Sql :: check constraint in ms sql
Sql :: max mysql
Sql :: number(10 2) in sql means
Sql :: drop tables from local database postgres pgadmin
Sql :: soql- select all fields
Sql :: how to put 0 or 000 depending IDCustomer length in sql server
Sql :: postgres advance table id count
Sql :: php select data from mysql database without column name
Sql :: mysql copy data from one table to another
Sql :: sql transfer table in other
Sql :: what are the data types in sql
Sql :: where name ends in SQL
Sql :: trigger sql server
Sql :: sorting desc in sql
Sql :: truncate in oracle sql
Sql :: sql like operator
Sql :: not in sql

Search

SQL

SQL Server modify_timestamp trigger

ADD CONTENT