SQL Stored procs vs. pass through query

M

Miskacee

which is better to use? I have parameters and know I must used stored
procedures for these queries, however, which is better for the other queries?

thank you.
 
J

Justo Morales

I suggest you use stored procedures if possible. Since they parse in
the server, subsequent runs will be faster. Plus, they are easier to
call from Access.
 
M

Miskacee

great. But I can't get my stored proc from sql 2005 to call from Access BE.
How do I do that?
 
Top