SQL SERVER 2000 DataType BIT [英] SQL SERVER 2000 DataType BIT
本文介绍了SQL SERVER 2000 DataType BIT的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
好伙伴,
我回来了,需要你的帮助。请帮帮我。
SQL SERVER 2000表。
DataType BIT的含义是什么,以及0和1的含义是什么。
值0(零)表示否或FALSE?
价值1(一)意味着是或是吗?
我对它感到很无助。请帮帮我
谢谢。
干杯,
Lennie
Hi Good Guys,
I am back and need your help. Please help me.
SQL SERVER 2000 Table.
What is the meaning of DataType BIT and also what''s the meaning of value 0 and 1.
Does value 0(zero) Means NO or FALSE ?
Does value 1 (one) Means YES or TRUE ?
I feel so helpless about it. Please Help me
Thank you.
Cheers,
Lennie
推荐答案
这是一个有点......是的,你可以将这些值翻译为真和假。 http://msdn.microsoft.com/en-us/ library / ms177603.aspx
It''s litterally a ''bit''... and yes you can translate the values as true and false. http://msdn.microsoft.com/en-us/library/ms177603.aspx
您好yarbrough40,
非常感谢您的帮助。
我尝试创建此SQL字符串用于检索我们公司产品供应商的活动状态并在DataGridView上显示详细信息,但它生成了此错误消息
''=''附近的语法不正确。
这是不起作用的SQL字符串
选择供应商ID,供应商名称,
iif(状态= 1,''活跃' ',''NotActive'')作为[状态]
来自TblSupplier
这个: iif(状态= 1,' 'Active'',''NotActive'')[Status] 生成错误信息
请帮帮我。谢谢。
干杯,
Lennie
Hi yarbrough40,
Thank you very much for your help.
I tried creating this SQL String to retrieve our company products supplier Active status and display the details on the DataGridView but it generated this error message
Incorrect syntax near ''=''.
Here is the SQL String that is not working
Select SupplierID, SupplierName,
iif (Status = 1, ''Active'', ''NotActive'') as [Status]
from TblSupplier
This :iif (Status = 1, ''Active'', ''NotActive'') as [Status] generated the error message
Please help me. Thanks.
Cheers,
Lennie
iif不支持sqlsqever。这是一个VBA功能。你需要使用CASE语句
iif is not supported with sqlsqever. That is a VBA function. you need to use a CASE statement
这篇关于SQL SERVER 2000 DataType BIT的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文