Stored Procedure: Insert row and retrieve scalar value as a result.

  • Thread starter Thread starter oranmeir
  • Start date Start date
O

oranmeir

Dear Friends,

I would like to create a stored procedore in access 2003 database.
that stored procedure should to the follow

CREATE PROCEDURE.....

INSERT INTO myTable(Coulmn1,Coulmn2,Coulmn3) VALUES (1,2,3);SELECT
@@IDENTITY;
....

I know that i can execute two queries one by one, but i preffer to do
it in one command as i am doing so with Microsoft SQL.

Somehow, i can not create and run that stored procedure while dealing
with Microsoft Access.

Any ideas?

Thanks.
 
Sorry, the Jet database engine does not support multiple SQL statements in
one query.
 
Back
Top