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
2017-01-29, 1275👍, 0💬
Related Topics:
