The BIT
data type is an integer value that accepts 0, 1, and NULL.
BIT
represents a boolean type with TRUE (1) and FALSE (0) values.
String values 'TRUE' and 'FALSE' are also accepted and converted to 1 and 0.
A table with a BIT
column.
CREATE TABLE DemoTable
(
Id INT IDENTITY,
MyBoolean BIT
);
GO
INSERT INTO DemoTable VALUES (1);
INSERT INTO DemoTable VALUES (0);
INSERT INTO DemoTable VALUES ('TRUE');
INSERT INTO DemoTable VALUES ('FALSE');
INSERT INTO DemoTable VALUES (NULL);
GO
SELECT * FROM DemoTable;
GO
DROP TABLE DemoTable;
GO
Id | MyBoolean |
---|---|
1 | 1 |
2 | 0 |
3 | 1 |
4 | 0 |
5 | NULL |
PRODUCT |
---|
Id |
ProductName |
SupplierId |
UnitPrice |
Package |
IsDiscontinued |
SELECT ProductName, IsDiscontinued
FROM Product
WHERE IsDiscontinued = 'TRUE'
ProductName | IsDiscontinued |
---|---|
Chef Anton's Gumbo Mix | 1 |
Mishi Kobe Niku | 1 |
Alice Mutton | 1 |
Guaraná Fantástica | 1 |
Rössle Sauerkraut | 1 |
Thüringer Rostbratwurst | 1 |
Singaporean Hokkien Fried Mee | 1 |
Perth Pasties | 1 |
Note: The 'TRUE' boolean string has been converted to 1. BIT values returned from the database are always 0, 1, or NULL.