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, 1760🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...