Programming in MS SQL Server 2012

Boolean Data Type


Boolean data value is a piece of information stated like True or False, On or Off, Yes or No and 1 or 0. BIT data type is used to stores Boolean data value in SQL Server. The following example describes a Boolean Data Type.

-- Example 73 --

 

DECLARE @IsMarried bit

SET @IsMarried = 1

SELECT @IsMarried AS [Is Married?]


Query Output Screen

* * * * *

Email Your Comment To AUTHOR

Quick Links
Home
About Me
System Analyze Method
Dimensional Data Model
Entity Relationship Model
Relational Database Model
Tutorials
MS SQL Server - DBA
SSIS - Video Tutorials
SSAS - Video Tutorials
SSRS - Video Tutorials
SQL Server White Papers
Programming in SQL Server
Help Us
Contact Me
R.K.Prem Nath
Madurai District
Tamil Nadu, India

[email protected]
[email protected]
Terms Of Use                                                  Protected by Copyscape Online Plagiarism Tool             Copyrights © . Data-e-Education. All Rights Reserved.