stored procedure

[iccsi]

I have a couple of queries need to run together.

I just wonder that can I run them together as a stored procedure.

If yes, are there any example on line?
Will stored procedure have better performance?


Your help is great appreciated,

 

[Albert D. Kallal]

I have a couple of queries need to run together.

I just wonder that can I run them together as a stored procedure.

If yes, are there any example on line?
Will stored procedure have better performance?


Your help is great appreciated,

Are you taking bout access, or sql server?

In ms-access you can use the coding language native to ms-access....

A routine in ms-access to run 3 queries would be:


Sub RunMy3Procs

currentdb.Execute "query1"
currentdb.Execute "query2"
currentdb.Execute "query3"

end sub

Will stored procedure have better performance?

Nah, no reason for this to be the case. Be it a stored procedure in sql
server, Oracle, MySql (if it has stored procs) or simply a code routine in
ms-access you not going to see any noticeable performance change here. There
are circumstances in which a stored proc can make differences on a server
based system, but without more details as your particular situation the
general answer is no...

 

[inungh]

Are you taking bout access, or sql server?

In ms-access you can use the coding language native to ms-access....

A routine in ms-access to run 3 queries would be:

Sub RunMy3Procs

   currentdb.Execute "query1"
   currentdb.Execute "query2"
   currentdb.Execute "query3"

end sub


Nah, no reason for this to be the case. Be it a stored procedure in sql
server, Oracle, MySql (if it has stored procs) or simply a code routine in
ms-access you not going to see any noticeable performance change here. There
are circumstances in which a stored proc can make differences on a server
based system, but without more details as your particular situation the
general answer is no...

Thanks millions