Insert Bool from Access Query into SQL Server database

Question

I am not sure how to insert boolean values from an Access query into a SQL Server table.

Access generally uses 0 for false, -1 for true. In SQL Server it's 1 for true.

So my question is this: if I want to insert a true value into my SQL Server table, can I just say -1 anyway, and SQL Server will know how to interpret it? Or do I have to put the 1 for true ?

EDIT: additionally, is it possible to just put true instead of a numeric value into the insert statement?

marc_s · Accepted Answer · 2016-02-12 10:31:58Z

7

Quick sample to illustrate:

CREATE TABLE BoolTest(SomeText VARCHAR(50), SomeBool BIT)

INSERT INTO dbo.BoolTest (SomeText, SomeBool)
VALUES ('Text 1', 0), (`Text 2', 1), ('Text 3', -1)

SELECT *
FROM dbo.BoolTest

I get this result:

So SQL Server interprets anything other than 0 as a True value.

answered Feb 12, 2016 at 10:31

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dagon313 Over a year ago

Thank you for the help and quick example !

Collectives™ on Stack Overflow

Insert Bool from Access Query into SQL Server database

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related