Very Computer

I'm trying to do an insert across 2 tables that have a primary key/foreign
key relationship. I want to use a stored procedure. I'm figuring that
nesting one stored procedure inside another would be a good idea, the first
could insert into the primary table and return the primary key as an Output
value, but I can't even find how to this.

Please help!

Steven

Steven

Quote:> Please help, there must be a simple solution to this, but I can't find it!

> I'm trying to do an insert across 2 tables that have a primary key/foreign
> key relationship. I want to use a stored procedure. I'm figuring that
> nesting one stored procedure inside another would be a good idea, the
first
> could insert into the primary table and return the primary key as an
Output
> value, but I can't even find how to this.

> Please help!

> Steven

Do you know the primary key at the moment you insert the record or
does it gets generated during the insert action?

When you know it beforehand, you don't need the output. When it gets
generated you have to query the database for the generated field and
return it.

Output parameters for a stored procedure are preceded with the
reserved word 'output'.

Regards, Hans