have a way to change order-by of open cursor?

have a way to change order-by of open cursor?mtczx232@.yahoo.com wrote:
> have a way to change order-by of open cursor?
No but why would you want to? A cursor perhaps isn't the best solution
(cursors rarely are). Please post DDL and sample data and maybe we can
help you with an alternative.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Indeed my question is that I want understand somthing about
MSAccess with SQL server.
I know that when we open SQL server table in MSAccess, it's work
with cursor. and it's build in Automatic refrash, that ditect if some
record
DELETE by other user or APP. So my wonder, how it's posible to sort
results set by one click?
Now i check it, I try with table with 3 million rec, I link this
table to Access by ODBC, and open it. I scroll until last record
to get the Numbers of all records in result in.
and I try sort it, The MSAccess run cursor again!! I see that
the number of all records is disappear. Now clear, MSAccess
run the cursor again. Notice, during all process the RAM consuming
by MSAcess not over 25M! so the Data remain on server.
After, I Try with MSAccess Project mode. the behavior is exectly like
ADO.NET with datatable. the MSAccess consume 450M!|||mtczx232@.yahoo.com wrote:
> Indeed my question is that I want understand somthing about
> MSAccess with SQL server.
> I know that when we open SQL server table in MSAccess, it's work
> with cursor. and it's build in Automatic refrash, that ditect if some
> record
> DELETE by other user or APP. So my wonder, how it's posible to sort
> results set by one click?
> Now i check it, I try with table with 3 million rec, I link this
> table to Access by ODBC, and open it. I scroll until last record
> to get the Numbers of all records in result in.
> and I try sort it, The MSAccess run cursor again!! I see that
> the number of all records is disappear. Now clear, MSAccess
> run the cursor again. Notice, during all process the RAM consuming
> by MSAcess not over 25M! so the Data remain on server.
>
> After, I Try with MSAccess Project mode. the behavior is exectly like
> ADO.NET with datatable. the MSAccess consume 450M!
This seems to be an Access question not a SQL Server one. I'm not
certain exactly what your question is though. Unless you specify ORDER
BY in your queries SQL Server will not apply any logical ordering to
your data. Do you have an ORDER BY clause in your query?
I have to say that scrolling through 3 million rows seems like an odd
thing to do - especially in a client-server database.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||David Portas
firstable I answer my q by my self, so if you not understand my answer,
ask directly. please read the entire msg.
first, I'm sure that you have certain experience with MSAccess.
second, this question need deep knowldedge with SQL like you have.
you are right, but MSAccess do that not bad, so it's nice to get
explanation how is work! in my answer I try to give one.