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, 1914🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
Where to find answers to frequently asked questions on CREATE, ALTER and DROP Statements in MySQL? H...