How do you create a yes/no boolean field in SQL server?

sql-server boolean sqldatatypes
leora picture leora · Nov 22, 2009 · Viewed 841.3k times · Source

What is the best practice for creating a yes/no i.e. Boolean field when converting from an access database or in general?

Answer

Guffa picture Guffa · Nov 22, 2009

The equivalent is a BIT field.

In SQL you use 0 and 1 to set a bit field (just as a yes/no field in Access). In Management Studio it displays as a false/true value (at least in recent versions).

When accessing the database through ASP.NET it will expose the field as a boolean value.

Related questions

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

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

Read More
SQL Server - boolean literal?

How to write literal boolean value in SQL Server? See sample use: select * from SomeTable where PSEUDO_TRUE another sample: if PSEUDO_TRUE begin select 'Hello, SQL!' end Note: The query above has nothing to do with how I'm …

Read More
How to set another value on a boolean with defaut value with Entity Framework Core?

I got quite the same problem in this question : How to override SQL Server default value constraint on a boolean when inserting new entity? [closed] Like him, I get the good value of my boolean from the client to the …

Read More