| |

VerySource

 Forgot password?
 Register
Search
View: 832|Reply: 6

May I use a cursor to retrieve the data height or use a subquery or a join such as join?

[Copy link]

4

Threads

4

Posts

5.00

Credits

Newbie

Rank: 1

Credits
5.00

 China

Post time: 2020-1-3 09:40:01
| Show all posts |Read mode
thanks
Reply

Use magic Report

0

Threads

100

Posts

53.00

Credits

Newbie

Rank: 1

Credits
53.00

 China

Post time: 2020-1-3 09:48:01
| Show all posts
You can try it and know the result.
Reply

Use magic Report

0

Threads

6

Posts

6.00

Credits

Newbie

Rank: 1

Credits
6.00

 China

Post time: 2020-1-16 20:36:01
| Show all posts
Try not to use cursors, because cursors perform poorly!
Reply

Use magic Report

0

Threads

66

Posts

27.00

Credits

Newbie

Rank: 1

Credits
27.00

 China

Post time: 2020-1-16 21:00:01
| Show all posts
Specific analysis
Reply

Use magic Report

0

Threads

4

Posts

3.00

Credits

Newbie

Rank: 1

Credits
3.00

 China

Post time: 2020-1-17 12:00:01
| Show all posts
Of course, it depends on the situation, but in general, if your sql statement can be implemented in these three ways
Join-Subqueries (Related Subqueries)-Cursors
Reply

Use magic Report

0

Threads

93

Posts

46.00

Credits

Newbie

Rank: 1

Credits
46.00

 United States

Post time: 2020-2-21 09:30:01
| Show all posts
It can't be compared, it depends on the specific situation
Reply

Use magic Report

0

Threads

28

Posts

25.00

Credits

Newbie

Rank: 1

Credits
25.00

 China

Post time: 2020-5-21 06:45:01
| Show all posts
Don't use cursors if you can use subqueries
Reply

Use magic Report

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

Points Rules

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

Quick Reply To Top Return to the list