blocks|key|2290007|text|您可以使用BIT数据类型来表示布尔数据。BIT字段的值为1、0或null。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2290008|entityMap^0|5|3|K|3|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

You could use the <code>BIT</code> datatype to represent boolean data. A <code>BIT</code> field's value is either 1, 0, or null.

blocks|key|3697210|text|您可能想要使用BIT数据类型，可能设置为NOT+NULL|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3697211|引用MSDN+article|3697212|3697213|+bit+(Transact-SQL)|blockquote|BOLD|3697214|3697215|可以接受值1、0或NULL的整数数据类型。|3697216|SQL+Server数据库引擎优化了位列的存储。如果表中有8个或更少的位列，则将这些列存储为1个字节。如果有9到16位的列，这些列将存储为2个字节，依此类推。|3697217|字符串值TRUE和FALSE可以转换为位值:+TRUE转换为1，FALSE转换为0。|3697218|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms177603.aspx|1^0|7|3|K|8|7|3|0|0|2|C|1|0|0|1|I|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@$9|13|A|14|B|C]|$9|15|A|16|B|C]]|D|@$9|17|A|18|1|19]]|E|$]]|$1|F|3|G|5|6|7|1A|8|@]|D|@$9|1B|A|1C|1|1D]]|E|$]]|$1|H|3|-4|5|6|7|1E|8|@]|D|@]|E|$]]|$1|I|3|J|5|K|7|1F|8|@$9|1G|A|1H|B|L]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|1I|8|@]|D|@]|E|$]]|$1|N|3|O|5|6|7|1J|8|@]|D|@]|E|$]]|$1|P|3|Q|5|6|7|1K|8|@]|D|@]|E|$]]|$1|R|3|S|5|6|7|1L|8|@]|D|@]|E|$]]|$1|T|3|-4|5|6|7|1M|8|@]|D|@]|E|$]]]|U|$V|$5|W|X|Y|E|$Z|10]]|11|$5|W|X|Y|E|$Z|10]]]]

You may want to use the <a href="http://msdn.microsoft.com/en-us/library/ms177603.aspx" rel="noreferrer"><code>BIT</code></a> data type, probably setting is as <code>NOT NULL</code>:
Quoting the <a href="http://msdn.microsoft.com/en-us/library/ms177603.aspx" rel="noreferrer">MSDN article</a>:
<blockquote>
bit (Transact-SQL)
An integer data type that can take a value of 1, 0, or NULL.
The SQL Server Database Engine optimizes storage of bit columns. If there are 8 or less bit columns in a table, the columns are stored as 1 byte. If there are from 9 up to 16 bit columns, the columns are stored as 2 bytes, and so on.
The string values TRUE and FALSE can be converted to bit values: TRUE is converted to 1 and FALSE is converted to 0.
</blockquote>

blocks|key|3697308|text|您正在寻找bit。它存储1或0(或NULL)。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3697309|或者，您可以使用字符串'true'和'false'代替1或0，如下所示-|3697310|declare+@b1+bit+=+'false'
print+@b1++++++++++++++++++++--prints+0

declare+@b2+bit+=+'true'
print+@b2++++++++++++++++++++--prints+1|code-block|syntax|javascript|3697311|此外，任何非0值(无论是正的还是负的)都会计算为(或在某些情况下转换为)+1。|3697312|declare+@i+int+=+-42
print+cast(@i+as+bit)++++--will+print+1,+because+@i+is+not+0|3697313|请注意，SQL+Server使用三值逻辑(true、false和NULL)，因为NULL可能是bit数据类型的值。以下是相关的真值表-|3697314|​|3697315|📷|atomic|3697316|3697317|关于三值逻辑的更多信息-|3697318|Example+of+three+valued+logic+in+SQL+Server|3697319|http://www.firstsql.com/idefend3.htm|3697320|https://www.simple-talk.com/sql/learn-sql-server/sql-and-the-snare-of-three-valued-logic/|3697321|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/4b438f45c88325707abc57746cd5fff0.png|imageAlt|1|LINK|MUTABLE|url|https://stackoverflow.com/questions/30539243/example-of-three-valued-logic-in-sql-server/30541165#30541165|2|3^0|5|3|H|4|0|B|6|I|7|0|0|0|0|L|4|Q|5|W|4|14|4|1B|3|0|0|0|1|0|0|0|0|0|17|1|0|0|10|2|0|0|2H|3|0^^$0|@$1|2|3|4|5|6|7|1M|8|@$9|1N|A|1O|B|C]|$9|1P|A|1Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1R|8|@$9|1S|A|1T|B|C]|$9|1U|A|1V|B|C]]|D|@]|E|$]]|$1|H|3|I|5|J|7|1W|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|1X|8|@]|D|@]|E|$]]|$1|O|3|P|5|J|7|1Y|8|@]|D|@]|E|$K|L]]|$1|Q|3|R|5|6|7|1Z|8|@$9|20|A|21|B|C]|$9|22|A|23|B|C]|$9|24|A|25|B|C]|$9|26|A|27|B|C]|$9|28|A|29|B|C]]|D|@]|E|$]]|$1|S|3|T|5|6|7|2A|8|@]|D|@]|E|$]]|$1|U|3|V|5|W|7|2B|8|@]|D|@$9|2C|A|2D|1|2E]]|E|$]]|$1|X|3|T|5|6|7|2F|8|@]|D|@]|E|$]]|$1|Y|3|Z|5|6|7|2G|8|@]|D|@]|E|$]]|$1|10|3|11|5|6|7|2H|8|@]|D|@$9|2I|A|2J|1|2K]]|E|$]]|$1|12|3|13|5|6|7|2L|8|@]|D|@$9|2M|A|2N|1|2O]]|E|$]]|$1|14|3|15|5|6|7|2P|8|@]|D|@$9|2Q|A|2R|1|2S]]|E|$]]|$1|16|3|-4|5|6|7|2T|8|@]|D|@]|E|$]]]|17|$18|$5|19|1A|1B|E|$1C|1D|1E|-4]]|1F|$5|1G|1A|1H|E|$1I|1J]]|1K|$5|1G|1A|1H|E|$1I|13]]|1L|$5|1G|1A|1H|E|$1I|15]]]]

<h3>You are looking for a <code>bit</code>. It stores 1 or 0 (or <code>NULL</code>).</h3>
Alternatively, you could use the strings <code>'true'</code> and <code>'false'</code> in place of 1 or 0, like so-
<pre><code>declare @b1 bit = 'false'
print @b1 --prints 0

declare @b2 bit = 'true'
print @b2 --prints 1
</code></pre>
Also, any non 0 value (either positive or negative) evaluates to (or converts to in some cases) a 1.
<pre><code>declare @i int = -42
print cast(@i as bit) --will print 1, because @i is not 0
</code></pre>
Note that SQL Server uses three valued logic (<code>true</code>, <code>false</code>, and <code>NULL</code>), since <code>NULL</code> is a possible value of the <code>bit</code> data type. Here are the relevant truth tables -
<a href="https://i.stack.imgur.com/e8JzB.png" rel="noreferrer"><img src="https://i.stack.imgur.com/e8JzB.png" alt="enter image description here" /></a>
More information on three valued logic-
<a href="https://stackoverflow.com/questions/30539243/example-of-three-valued-logic-in-sql-server/30541165#30541165">Example of three valued logic in SQL Server</a>
<a href="http://www.firstsql.com/idefend3.htm" rel="noreferrer">http://www.firstsql.com/idefend3.htm</a>
<a href="https://www.simple-talk.com/sql/learn-sql-server/sql-and-the-snare-of-three-valued-logic/" rel="noreferrer">https://www.simple-talk.com/sql/learn-sql-server/sql-and-the-snare-of-three-valued-logic/</a>

blocks|key|2290215|text|SQL+Server中存在boolean数据类型。它的值可以是TRUE、FALSE或UNKNOWN。但是，布尔数据类型只是包含代码(例如=、<>、<、>=)或代码(例如AND、OR、IN、<代码>d12logical+operators+>)某种组合的布尔表达式的结果。布尔表达式只允许在少数地方使用，包括WHERE子句、HAVING子句、CASE+expression的WHEN子句或IF或WHILE流控制语句的谓词。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2290216|对于所有其他用法，包括表中列的数据类型，不允许使用boolean。对于其他用法，首选BIT数据类型。它的行为类似于缩小范围的INTEGER，只允许值0、1和NULL，除非使用NOT+NULL列约束或CHECK约束进一步限制。|2290217|要在布尔表达式中使用BIT列，需要使用比较运算符进行比较，例如=、<>或IS+NULL。例如：|2290218|SELECT
++++a.answer_body
FROM+answers+AS+a
WHERE+a.is_accepted+=+0;|code-block|syntax|javascript|2290219|从格式的角度来看，在客户端软件中，bit值通常显示为0或1。当需要更加用户友好的格式，并且它不能在数据库前面的应用层处理时，可以使用CASE表达式进行“即时”转换，例如|2290220|SELECT
++++a.answer_body,
++++CASE+a.is_accepted+WHEN+1+THEN+'TRUE'+ELSE+'FALSE'+END+AS+is_accepted
FROM+answers+AS+a;|2290221|将布尔值存储为字符数据类型(如char(1)或varchar(5)+)也是可能的，但这不是很清楚，具有更多的存储/网络开销，并且需要每列上的CHECK约束来限制非法值。|2290222|作为参考，answers表的模式类似于：|2290223|CREATE+TABLE+answers+(
++++...,
++++answer_body+nvarchar(MAX)+NOT+NULL,
++++is_accepted+bit+NOT+NULL+DEFAULT+(0)
);|2290224|entityMap|0|LINK|mutability|MUTABLE|url|https://msdn.microsoft.com/en-us/library/ms188047.aspx|1|https://msdn.microsoft.com/en-us/library/ms180199.aspx|2|https://msdn.microsoft.com/en-us/library/ms181765.aspx|3|https://msdn.microsoft.com/en-us/library/ms182717.aspx|4|https://msdn.microsoft.com/en-us/library/ms178642.aspx|5|https://msdn.microsoft.com/en-us/library/ms177603.aspx^0|V|4|10|5|16|7|1W|1|1Y|2|21|1|23|2|2C|3|2G|2|2J|2|49|5|4H|6|4Q|4|56|4|5D|2|5G|5|49|5|0|4H|6|1|4Q|F|2|5D|2|3|5G|5|4|0|16|3|1Q|7|22|1|24|1|26|4|2F|8|2R|5|16|3|5|0|A|3|V|1|X|2|10|7|0|0|H|3|Q|1|S|1|1U|4|0|0|F|7|N|A|1Y|5|0|5|7|0|0^^$0|@$1|2|3|4|5|6|7|1G|8|@$9|1H|A|1I|B|C]|$9|1J|A|1K|B|C]|$9|1L|A|1M|B|C]|$9|1N|A|1O|B|C]|$9|1P|A|1Q|B|C]|$9|1R|A|1S|B|C]|$9|1T|A|1U|B|C]|$9|1V|A|1W|B|C]|$9|1X|A|1Y|B|C]|$9|1Z|A|20|B|C]|$9|21|A|22|B|C]|$9|23|A|24|B|C]|$9|25|A|26|B|C]|$9|27|A|28|B|C]|$9|29|A|2A|B|C]|$9|2B|A|2C|B|C]]|D|@$9|2D|A|2E|1|2F]|$9|2G|A|2H|1|2I]|$9|2J|A|2K|1|2L]|$9|2M|A|2N|1|2O]|$9|2P|A|2Q|1|2R]]|E|$]]|$1|F|3|G|5|6|7|2S|8|@$9|2T|A|2U|B|C]|$9|2V|A|2W|B|C]|$9|2X|A|2Y|B|C]|$9|2Z|A|30|B|C]|$9|31|A|32|B|C]|$9|33|A|34|B|C]|$9|35|A|36|B|C]]|D|@$9|37|A|38|1|39]]|E|$]]|$1|H|3|I|5|6|7|3A|8|@$9|3B|A|3C|B|C]|$9|3D|A|3E|B|C]|$9|3F|A|3G|B|C]|$9|3H|A|3I|B|C]]|D|@]|E|$]]|$1|J|3|K|5|L|7|3J|8|@]|D|@]|E|$M|N]]|$1|O|3|P|5|6|7|3K|8|@$9|3L|A|3M|B|C]|$9|3N|A|3O|B|C]|$9|3P|A|3Q|B|C]|$9|3R|A|3S|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|L|7|3T|8|@]|D|@]|E|$M|N]]|$1|S|3|T|5|6|7|3U|8|@$9|3V|A|3W|B|C]|$9|3X|A|3Y|B|C]|$9|3Z|A|40|B|C]]|D|@]|E|$]]|$1|U|3|V|5|6|7|41|8|@$9|42|A|43|B|C]]|D|@]|E|$]]|$1|W|3|X|5|L|7|44|8|@]|D|@]|E|$M|N]]|$1|Y|3|-4|5|6|7|45|8|@]|D|@]|E|$]]]|Z|$10|$5|11|12|13|E|$14|15]]|16|$5|11|12|13|E|$14|17]]|18|$5|11|12|13|E|$14|19]]|1A|$5|11|12|13|E|$14|1B]]|1C|$5|11|12|13|E|$14|1D]]|1E|$5|11|12|13|E|$14|1F]]]]

There is boolean data type in SQL Server. Its values can be <code>TRUE</code>, <code>FALSE</code> or <code>UNKNOWN</code>. However, the boolean data type is only the result of a boolean expression containing some combination of <a href="https://msdn.microsoft.com/en-us/library/ms188074.aspx">comparison operators</a> (e.g. <code>=</code>, <code>&lt;&gt;</code>, <code>&lt;</code>, <code>&gt;=</code>) or <a href="https://msdn.microsoft.com/en-us/library/ms189773.aspx">logical operators</a> (e.g. <code>AND</code>, <code>OR</code>, <code>IN</code>, <code>EXISTS</code>). Boolean expressions are only allowed in a handful of places including the <a href="https://msdn.microsoft.com/en-us/library/ms188047.aspx"><code>WHERE</code></a> clause, <a href="https://msdn.microsoft.com/en-us/library/ms180199.aspx"><code>HAVING</code></a> clause, the <code>WHEN</code> clause of a <a href="https://msdn.microsoft.com/en-us/library/ms181765.aspx"><code>CASE</code> expression</a> or the predicate of an <a href="https://msdn.microsoft.com/en-us/library/ms182717.aspx"><code>IF</code></a> or <a href="https://msdn.microsoft.com/en-us/library/ms178642.aspx"><code>WHILE</code></a> flow control statement. 

For all other usages, including the data type of a column in a table, boolean is not allowed. For those other usages, the <a href="https://msdn.microsoft.com/en-us/library/ms177603.aspx"><code>BIT</code></a> data type is preferred. It behaves like a narrowed-down <code>INTEGER</code> which allows only the values <code>0</code>, <code>1</code> and <code>NULL</code>, unless further restricted with a <code>NOT NULL</code> column constraint or a <code>CHECK</code> constraint.

To use a <code>BIT</code> column in a boolean expression it needs to be compared using a comparison operator such as <code>=</code>, <code>&lt;&gt;</code> or <code>IS NULL</code>. e.g.

<pre><code>SELECT
 a.answer_body
FROM answers AS a
WHERE a.is_accepted = 0;
</code></pre>

From a formatting perspective, a <code>bit</code> value is typically displayed as <code>0</code> or <code>1</code> in client software. When a more user-friendly format is required, and it can't be handled at an application tier in front of the database, it can be converted "just-in-time" using a <code>CASE</code> expression e.g.

<pre><code>SELECT
 a.answer_body,
 CASE a.is_accepted WHEN 1 THEN 'TRUE' ELSE 'FALSE' END AS is_accepted
FROM answers AS a;
</code></pre>

Storing boolean values as a character data type like <code>char(1)</code> or <code>varchar(5)</code> is also possible, but that is much less clear, has more storage/network overhead, and requires <code>CHECK</code> constraints on each column to restrict illegal values.

For reference, the schema of <code>answers</code> table would be similar to:

<pre><code>CREATE TABLE answers (
 ...,
 answer_body nvarchar(MAX) NOT NULL,
 is_accepted bit NOT NULL DEFAULT (0)
);
</code></pre>

blocks|key|3697114|text|可以使用SQL+Server中的Bit+DataType来存储布尔数据。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3697115|entityMap^0|G|3|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

You can use <code>Bit</code> DataType in SQL Server to store boolean data.

blocks|key|2290017|text|使用Bit数据类型。在原生T-SQL中处理它时，它具有值1和0|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2290018|entityMap^0|2|3|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Use the <code>Bit</code> datatype. It has values 1 and 0 when dealing with it in native T-SQL

blocks|key|1410565|text|SQL+Server使用Bit数据类型|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1410566|entityMap^0|C|3|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

SQL Server uses the <code>Bit</code> datatype

blocks|key|1406631|text|使用BIT数据类型来表示布尔数据。BIT字段的值为1,0或NULL。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1406632|create+table+<tablename>+(
++++<columnName>+bit
)|code-block|syntax|javascript|1406633|除非你想要一个三元布尔值，否则你应该添加非空默认值0，如下所示：|1406634|create+table+<tablename>+(
++++<columnName>+bit+not+null+default+0
)|1406635|entityMap^0|2|3|H|3|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|W|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|X|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|P|$]]

Use the <code>BIT</code> datatype to represent boolean data. A <code>BIT</code> field's value is either 1,0 or NULL.

<pre><code>create table &lt;tablename&gt; (
 &lt;columnName&gt; bit
)
</code></pre>

Unless you want a threeway boolean you should add NOT NULL DEFAULT 0 like so:

<pre><code>create table &lt;tablename&gt; (
 &lt;columnName&gt; bit not null default 0
)
</code></pre>

blocks|key|3697433|text|我使用TINYINT(1)数据类型是为了在SQL+Server中存储布尔值，尽管BIT非常有效|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3697434|entityMap^0|3|A|14|3|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|M|8|@]|D|@]|E|$]]]|G|$]]

I use <code>TINYINT(1)</code>datatype in order to store boolean values in SQL Server though <code>BIT</code> is very effective

Is there a Boolean data type in Microsoft SQL Server like there is in MySQL?
If not, what is the alternative in MS SQL Server?

Is there a Boolean data type in Microsoft SQL Server like there is in MySQL?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

Microsoft SQL Server中是否有像MySQL中那样的布尔数据类型？如果不是，MS SQL Server中的替代方案是什么？

问Microsoft SQL Server中是否有像MySQL中那样的布尔数据类型？
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Microsoft SQL Server中是否有像MySQL中那样的布尔数据类型？EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Microsoft SQL Server中是否有像MySQL中那样的布尔数据类型？
EN