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

Question

How should a yes/no, or boolean, field be created when converting from an Access database or generally?

Answer 1

A BIT field serves as a substitute. Similar to a yes/no field in Access, a bit field in SQL is set using the values 0 and 1. It appears in Management Studio as a false/true value (at least in recent versions).

The field will be made available as a boolean value when ASP.NET is used to access the database.

I hope this helps you.