How to realize this in Transact SQL ( SQL Server 2008 )
Posted
by David
on Stack Overflow
See other posts from Stack Overflow
or by David
Published on 2010-06-07T22:02:15Z
Indexed on
2010/06/07
22:12 UTC
Read the original article
Hit count: 165
I just want an update trigger like this postgresql version... It seems to me there is no NEW. and OLD. in MSSQL?
CREATE OR REPLACE FUNCTION "public"."ts_create" () RETURNS trigger AS
DECLARE
BEGIN
NEW.ctime := now();
RETURN NEW;
END;
Googled already, but nothing to be found unfortunately... Ideas?
© Stack Overflow or respective owner