how do you create a yes/no boolean field in sql server

Question

what is the best practice for this when converting from an access database or in general

Answer 1

The BIT datatype is generally used to store boolean values (0 for false, 1 for true).

Answer 2

You can use the bit column type.

Answer 3

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 ASO.NET it will expose the field as a boolean value.

Answer 4

bit will be the simplest and also takes up the least space. Not very verbose compared to "Y/N" but I am fine with it.