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, 2192🔥, 0💬
Popular Posts:
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...