Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tungdt
Starting Member
7 Posts |
 Posted - 2012-02-06 : 08:07:06
|
How can get percent of server when I select query?For example,I have a query "SELECT * FROM TABLE_AAAA"TABLE_AAAA has X records (X = a number).I have a progress bar, value of progress from 1->100. When database fetch X/100 records progress bar automatic add 1 to its. When quey fetching is 100%, for progress bar is full. A new message is on : 100% database records is fetched to your memory, for example.How can I do that ?Any one can help me  Thank alots. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-02-06 : 08:14:24
|
| I am not aware of a T-SQL feature that would allow you to retrieve the progress status of a query. When you send that query to the server, it is processed as a set. It takes in your query, and returns the whole thing as one set, in one shot to you, so not sure how one could even logically think of a progress status. |
 |
|
|
tungdt
Starting Member
7 Posts |
Posted - 2012-02-06 : 08:21:30
|
quote:
Originally posted by sunitabeck
I am not aware of a T-SQL feature that would allow you to retrieve the progress status of a query. When you send that query to the server, it is processed as a set. It takes in your query, and returns the whole thing as one set, in one shot to you, so not sure how one could even logically think of a progress status.
Haizz, so I can't do this work with SQL SERVER !Okie, but I still wait someone, who has a solution. Thank you alot |
|
|
|
tungdt
Starting Member
7 Posts |
Posted - 2012-02-06 : 09:08:07
|
| Anyone have a solution ???? help me plz, I stuck :D |
|
|
|
|
|
|
|
|
Get percent of query in database