<cfquery name="

" datasource="">
create trigger TRIGGER_NAME
on TABLENAME
for
insert as select
COLUMN_TO_RETURN
from inserted
</cfquery>

TRIGGER_NAME = the name of trigger
TABLENAME = the name of table
COLUMN_TO_RETURN = the name of the column data to return (i.e ID)