Lets say I use the standard insert trigger like so:
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?
Thanks,
Neil
p.s. Maybe someone knows why CFTree's folder image doesn't work on one of my
server?! Thanks.....
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
