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, 1662🔥, 0💬
Popular Posts:
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...