> CREATE TRIGGER GetMax_ID ON mytable
> FOR INSERT
> AS
> SELECT mytable_ID FROM INSERTED
>
> How would I reference the result within a stored procedure to insert
> the "mytable_id" in the next query?
Neil
I don't think you can pass a value out from a trigger - once the trigger
is created it exists independently of the rest of your code. But you
could put all the logic inside the trigger, or have the trigger call
a procedure with all the logic inside it.
Nick
**********************************************************************
Information in this email is confidential and may be privileged.
It is intended for the addressee only. If you have received it in error,
please notify the sender immediately and delete it from your system.
You should not otherwise copy it, retransmit it or use or disclose its
contents to anyone.
Thank you for your co-operation.
**********************************************************************
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
