How to create a yes/no boolean field in SQL server?
boolean, database, sql-server, sqldatatypes, tablecolumn
Solution
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.
Problem
What is the best practice for creating a `yes/no` i.e. `Boolean` field when converting from an `access database` or in general?