| |

VerySource

 Forgot password?
 Register
Search
View: 11|Reply: 3

Does access support batch query?

[Copy link]

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-3-2 15:00:01
| Show all posts |Read mode
My SQL is written as: SQL = "setlect * from table1; select * from table2;"
But write the system prompt like this:
  Syntax error: there is a statement after the SQL statement
    what's up?
 Does access not support batch query ???????????????
Reply

Use magic Report

0

Threads

11

Posts

10

Credits

Newbie

Rank: 1

Credits
10

 China

Post time: 2020-5-12 22:30:01
| Show all posts
Not supported, execute one by one
Reply

Use magic Report

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

 Author| Post time: 2020-5-13 12:15:01
| Show all posts
No support? Can only be executed one by one! It really makes me depressed.
Thank youcairui1
Reply

Use magic Report

0

Threads

11

Posts

10

Credits

Newbie

Rank: 1

Credits
10

 China

Post time: 2020-5-13 19:15:02
| Show all posts
Yes, SQL SERVER can be executed, ACCESS can't
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