What Is a Boolean Value in SQL Server

Q

What Is a Boolean Value in SQL Server Transact-SQL?

✍: FYIcenter.com

A

A Boolean value indicates a condition in a state of TRUE or FALSE. In Transact-SQL language, there is not storage data type defined to store a Boolean value. So Boolean values can only exist temporarily as part of the execution of Transact-SQL expression or statement.

Boolean values are returned from comparison operations. The tutorial exercise below shows you some examples of how Boolean values are used: 

-- Boolean values in a CASE expression
SELECT CASE WHEN 1>0 THEN
      'True'
   ELSE
      'False'
   END;
GO
True

-- Boolean values in an IF statement
IF 1>0 
   SELECT 'True';
ELSE
   SELECT 'False';
GO
True

-- Stand alone Boolean value not allowed 
SELECT 1>0;
GO
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '>'.

 

⇒Boolean Values and Logical Operations in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2017-01-29, 463👍, 0💬

General MySQL Oracle SQL Server