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

Filed under:
|
|

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

Related posts about sql

Related posts about sql-server