| |

VerySource

 Forgot password?
 Register
Search
View: 19|Reply: 5

How to implement stored procedures with parameters in access

[Copy link]

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-2-21 05:00:01
| Show all posts |Read mode
How to implement stored procedures with parameters in access. Please help, I urgently need 11111111
I want an example, thank you;
Reply

Use magic Report

0

Threads

11

Posts

10

Credits

Newbie

Rank: 1

Credits
10

 China

Post time: 2020-4-29 16:45:01
| Show all posts
There is no stored procedure in ACCESS. Only query.
Reply

Use magic Report

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 Invalid IP Address

 Author| Post time: 2020-4-30 11:30:03
| Show all posts
Is it impossible to take parameters?
Reply

Use magic Report

0

Threads

11

Posts

10

Credits

Newbie

Rank: 1

Credits
10

 China

Post time: 2020-4-30 20:45:01
| Show all posts
Can take parameters
try:
select * from tt where tj = [cs]
Reply

Use magic Report

0

Threads

20

Posts

12

Credits

Newbie

Rank: 1

Credits
12

 China

Post time: 2020-5-22 13:30:02
| Show all posts
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.
Reply

Use magic Report

0

Threads

4

Posts

5

Credits

Newbie

Rank: 1

Credits
5

 China

Post time: 2020-5-27 15:45:01
| Show all posts
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
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list