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
  2. gaurav_bindlish New Member

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

  3. bambola New Member

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

  4. vbkenya New Member

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


Share This Page