How to implement stored procedures with parameters in access

hjchqian

How to implement stored procedures with parameters in access. Please help, I urgently need 11111111
I want an example, thank you;

cairui1

There is no stored procedure in ACCESS. Only query.

hjchqian

Is it impossible to take parameters?

cairui1

Can take parameters
try:
select * from tt where tj = [cs]

小老鹰

Is there a stored procedure in access? How to use it?

-------------------------------------------------- ------------------------

Access itself has no stored procedures, but there are queries.

Access uses Jet-SQL, which is very different from T-SQL used by SQL Server.

Such as: Access query can only execute one SQL statement at a time, while SQL Server stored procedures can put many SQL statements.


If you use the ADP project, you can edit the SQL Server stored procedure in Access, or execute it.

blackstar

create producre ttt (
@id varchar (245),
@name int
) as
(
select * from pubs where id = @id
)

conn.execute ("ttt 12,123")
But to be the nextasscess database browser

小老鹰

Access supports query with parameters, but does not support stored procedures.


--Such as:

select * from table name where field name = [input parameter value]