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.
Â
⇒Boolean Values and Logical Operations in SQL Server Transact-SQL
2017-01-11, 2121🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...