Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dynamic SQL query in a cursor
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00485420
Message ID:
00486468
Views:
17
>I don't see anything obvious. If it works and the performance is acceptable, go with it.

Actually I just found that performance is lower than what I have with VB and I don't understand why!

Performance was acceptable in my tests because I was always querying for the same table (@NomTable) and the same field (@NomChamp). As soon as I give other field, performance is not acceptable (25 to 30 seconds to process 240 rows).
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform