Collections:
What Are Logical/Boolean Operations in SQL Server
What Are Logical/Boolean Operations in SQL Server Transact-SQL?
✍: FYIcenter.com
Logical (Boolean) operations are performed on Boolean values with logical operators like 'AND', 'OR', or 'NOT'. Logical operations return Boolean values. SQL Server 2005 supports the following logical operations:
Logical operations are commonly used to combine Boolean values resulted from comparison operations. The following tutorial exercise shows you a good example:
DECLARE @income MONEY;
DECLARE @marriage_status VARCHAR(10);
SET @income = 55000.00;
SET @marriage_status = 'Single';
SELECT CASE WHEN
(@marriage_status = 'Married' AND @income < 65000)
OR (@marriage_status = 'Single' AND @income < 35000)
THEN 'Qualified for the benefit.'
ELSE 'Not qualified for the benefit.'
END;
GO
Not qualified for the benefit.
⇒ Conditional Statements and Loops in SQL Server in SQL Server Transact-SQL
⇐ IN - Testing Values Returned by a Subquery in SQL Server
⇑ Boolean Values and Logical Operations in SQL Server Transact-SQL
2017-01-11, 4094🔥, 0💬
Popular Posts:
How To View Data Files in the Current Database in Oracle? If you want to get a list of all tablespac...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How to detect the collation coercibility associated to a given character string using the COERCIBILI...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...