Re: Query Result
Date: 25 Jan 2005 02:57:47 -0800
It is possible to write non-deterministic queries in Transact SQL. For
example it is quite possible to retrieve a different set of data on
successive queries using SELECT TOP without ORDER BY. This is by
design. If you want repeatable results you need to write deterministic
queries. If your tables are constantly being updated in a live system
however, then what result do you expect?
--
David Portas
SQL Server MVP
--
Relevant Pages
- Re: White Paper on How MSAccess interacts with SQL Server Back End?
... this newsgroup is about ADP and has nothing to do with ODBC linked ... For simple queries, Access will create a TSQL queries that will run on the ... these keys to retrieve the other fields from the tables by group of 10 rows. ... access path, hands it off os SQL2K, how SQL interprets it and then ...
(microsoft.public.access.adp.sqlserver) - Re: hibernate question
... Daniel wrote: ... > queries to retrieve the data run fine, but every time I try to save ... The hibernate.show_sql config option is the easiest way to ...
(comp.lang.java.programmer) - Re: First of and last of help!
... >the totals in queries (despite having done a search in this group and ... the physical order of records gets rearranged if you ... retrieve an arbitrary record's value, ... date/time field in the table and use a query searching for the maximum ...
(microsoft.public.access.queries) - Re: Many-to-many self-relationships
... This would have the disadvantage of needing a union of two queries whenever you needed to retrieve all the links connected to a particular Person. ... Rick Bowlby ...
(comp.databases) - Re: Listing objects (tables and queries) within a query
... I have a number of queries that have a problem with a join ... local MS-Access table and the other is a linked SQL Server db table. ... I need to retrieve the matched records somehow. ...
(microsoft.public.access.modulesdaovba) |
|
