SQL Server Performance

conditions in sql

Discussion in 'General Developer Questions' started by yamani, Jun 4, 2003.

  1. yamani New Member

    hi can i help me y ned make a condition whit if because i need compare tow types of dats for example :

    if a<>b and x=y then z

    and i need traduce this line to sql.

    thank you
    yamani, Jun 4, 2003
    #2

  2. gaurav_bindlish New Member

    IF (A<>b) AND (X=Y)
    <Execution of Z begins>

    Gaurav
    gaurav_bindlish, Jun 4, 2003
    #2

  3. bambola New Member

    And if your condition is inside a query, you can check BOL for CASE statement.

    Bambola.
    bambola, Jun 4, 2003
    #2

  4. vbkenya New Member

    ....plus some of the complications of data comparison operations
    1. Collations for character data types
    2. Data type precendence issues


    NHO
    vbkenya, Jun 5, 2003
    #2

Share This Page