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, 2200🔥, 0💬
Popular Posts:
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...