Collections:
What Is a Boolean Value in SQL Server
What Is a Boolean Value in SQL Server Transact-SQL?
✍: FYIcenter.com
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 '>'.
⇒ CASE - Conditional Expressions in SQL Server
⇐ Boolean Values and Logical Operations in SQL Server Transact-SQL
⇑ Boolean Values and Logical Operations in SQL Server Transact-SQL
2017-01-29, 1661🔥, 0💬
Popular Posts:
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...