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, 2197🔥, 0💬
Popular Posts:
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...