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, 239👍, 0💬