Empty Table?

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

From: Marc Meltzer <mrmeltzer@xxxxxxxxxx>
Date: Fri, 31 Mar 2006 10:31:55 -0500

What query can I run to determine if a table is empty? I have a placeholder table where whatever values it contains will be copied into another table. I want to make sure that the table is not empty before proceeding.

Thank you!
Marc
.

Follow-Ups:
- Re: Empty Table?
  - From: Tom Ellison

Prev by Date: Re: Equilevant of Oracle for optional records
Next by Date: Re: Query Problem - Two or More Records
Previous by thread: Re: Complex Autonumber Problem in a query
Next by thread: Re: Empty Table?
Index(es):
- Date
- Thread

Relevant Pages

Cant resolve aol.com anymore.. but can other domains
... 12 Flags A = Authoritative Answer ... OPCODE 0 (QUERY) ... RCODE 0 (NOERROR) ...
(microsoft.public.windows.server.dns)
Re: Cant resolve aol.com anymore.. but can other domains
... 12 Flags A = Authoritative Answer ... OPCODE 0 (QUERY) ... RCODE 0 (NOERROR) ...
(microsoft.public.windows.server.dns)
Re: Dimension performance (newbie question)
... Do you know how much time is taken in MDX query execution versus report ... How to Increase the Speed of MDX Queries that Contain the NON EMPTY ... Empty Behavior property for the calculated member. ...
(microsoft.public.sqlserver.olap)
RE: Synchronized Combo Boxes
... second combo box, the list is empty. ... Then, create a new query. ... Private Sub cboRepl_Fixture_AfterUpdate ... Dim strSQL As String ...
(microsoft.public.access.forms)
Re: getting an empty tuple
... >> rows that the query selected. ... None is not a tuple, nor a long int, so testing ... > a great language for experimenting, because you can try this yourself: ... what shoud i do to test if the result is empty? ...
(comp.lang.python)