Query Result

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Adeel Aslam (Aslam_at_discussions.microsoft.com)
Date: 01/25/05 

Date: Tue, 25 Jan 2005 02:39:03 -0800

Dear people,

i want to know that when i run a query on the SQL server QueryAnalazer then
it gives me the different results when executed again and agian. The
database is the live one. But if i back up the database and migrate it with
different name having no live connection it gives the consistent result. so
what is the problem and how to solve the problem.

Even if i write select count(*) From Table A then again it gives differnet
result when i execute the query.
Waiting for the reply

Thanks ,

Adeel Aslam

Relevant Pages

  • Re: Newbie question about formula based values
    ... if the query hangs or if Access crashes or is someone restarts ... If you want to execute the code from your web site, you can do that as well. ... If your web site can execute SQL code against an Access database, ... In Windows scheduler, create a new scheduled task based on Microsoft ...
    (comp.databases.ms-access)
  • TIP #308: Twylites concerns
    ... If, as you say, the simple change of adding a place for [$db execute] ... likely the result of a query against a system catalog. ... > especially for a pure-Tcl implementation for a specific database. ... 'execute' functionality that you discussed above address this concern? ...
    (comp.lang.tcl)
  • Re: .Execute vs. .RunSQL - Speed vs. Size
    ... >to know which is faster - Dim a database and then use the db.execute method ... Execute a sequence of action queries. ... Note that Execute requires you to resolve any query ... can gain orders of magnitude better improvement by making ...
    (microsoft.public.access.formscoding)
  • Re: disable index while doing insert into
    ... source and target table have multiple indexes, ... to execute this query but when i've deleted the indexes on target ... This is a price you have to pay on any database not just Sybase. ...
    (comp.databases.sybase)
  • Re: Execute queries in back-end database via ADO !?!
    ... > I found that by defining an ADO connection to my back end database, ... execute a SQL query stored in my back end database. ... As long as your data is stored in an MDB file all query processing is ... What program would you expect to execute the query on the back end? ...
    (microsoft.public.access.queries)