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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Stored Procedure Returns No Results 1
Access pass-through query to Oracle 10g stored procedure - results 1
Stored Procedures and Access 2003 Professional 1
Creating a stored procedure (query) in access 3
Stored procedure wont insert Fields, RadioButtonLists and CheckBox 1
Stupid question - binding an <asp:label> --> stored procedure returning a scalar? 3
Help with calling Stored Procedure on SQL Server 5

Back
Top