<cfquery name="" datasource=""> create trigger TRIGGERNAME on TABLENAME for insert as select COL_TO_RETURN from inserted </cfquery> TRIGGERNAME: name of trigger TABLENAME: name of table COL_TO_RETURN: column to return i.e USERID