SQL Server和Access的布尔表示不同 [英] SQL Server and Access differ in their boolean representation
问题描述
我有MS Access 2007 应用程序链接到SQL Server 2005,在访问视图中,布尔值显示为0表示False,-1表示True,对于False应该为0,对于True应该为1。
I have MS Access 2007 application linked to SQL Server 2005, In the access view, the boolean values are displayed as 0 for False and -1 for True, which should have been 0 for False and 1 for True.
如何在MS Access中复制相同的内容,在SQL Server表中是否存在布尔值?
How to replicate the same in MS Access, which is there in SQL Server table for the boolean values?
推荐答案
你好,
我很擅长Access的专家,但我建议你这个链接:
I am far to be a specialist of Access , but i would suggest you this link :
不要犹豫再次发布更多信息帮助或解释。
Don't hesitate to post again for more help or explanations.
祝你有愉快的一天
PS:请问,你能告诉我们SQL Server实例和MS之间的联系是什么访问? Access是否仅用于在SQL Server实例表中加载数据?
PS : Please, could you tell us what is the link between the SQL Server instance and the MS Access ? Is Access only used to load data in the SQL Server instances tables ?
这篇关于SQL Server和Access的布尔表示不同的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!