Re: Qualify customer information

From: Anith Sen (anith_at_bizdatasolutions.com)
Date: 10/13/04

  • Next message: chazz: "multi-table record count" 
    Date: Wed, 13 Oct 2004 15:51:44 -0500

    Your post contains several broad questions which cannot be aptly answered
    without more specifics. In general, when customer information is recorded in
    a database uniquely, one can use a simple IF EXISTS() check to see if a
    specific row exists in a table. For instance:

    IF EXISTS ( SELECT * FROM tbl WHERE keycol = @someval )
            -- Data exists
    ELSE
            -- Data does not exist

    Depending on what attributes ( like name, address, email etc. ) make up a
    unique customer in your table, you may have to make use of a proper
    predicate which can identify the row. 

    -- 
Anith
  • Next message: chazz: "multi-table record count"