AND (Transact-SQL)

AND (Transact-SQL)

 

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2008) yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

Combines two Boolean expressions and returns TRUE when both expressions are TRUE. When more than one logical operator is used in a statement, the AND operators are evaluated first. You can change the order of evaluation by using parentheses.

Topic link icon Transact-SQL Syntax Conventions


boolean_expression AND boolean_expression
-- Azure SQL Data Warehouse and Parallel Data Warehouse
      boolean_expression AND boolean_expression

boolean_expression

Is any valid expression that returns a Boolean value: TRUE, FALSE, or UNKNOWN.

Returns TRUE when both expressions are TRUE.

The following chart shows the outcomes when you compare TRUE and FALSE values by using the AND operator.

 

TRUE

FALSE

UNKNOWN

TRUE

TRUE

FALSE

UNKNOWN

FALSE

FALSE

FALSE

FALSE

UNKNOWN

UNKNOWN

FALSE

UNKNOWN

The following example selects information about employees who have both the title of Marketing Assistant and more than 41 vacation hours available.

-- Uses AdventureWorks

SELECT  BusinessEntityID, LoginID, JobTitle, VacationHours 
FROM HumanResources.Employee
WHERE JobTitle = 'Marketing Assistant'
AND VacationHours > 41 ;

The following examples show how to use AND in an IF statement. In the first statement, both 1 = 1 and 2 = 2 are true; therefore, the result is true. In the second example, the argument 2 = 17 is false; therefore, the result is false.

IF 1 = 1 AND 2 = 2
BEGIN
   PRINT 'First Example is TRUE'
END
ELSE PRINT 'First Example is FALSE';
GO

IF 1 = 1 AND 2 = 17
BEGIN
   PRINT 'Second Example is TRUE'
END
ELSE PRINT 'Second Example is FALSE' ;
GO

Community Additions

ADD
Show:
© 2016 Microsoft