What is the best practice for creating a yes/no
i.e. Boolean
field when converting from an access database
or in general?
Sql-server – How to create a yes/no boolean field in SQL server
booleansql serversqldatatypes
Related Topic
- Sql – Add a column with a default value to an existing table in SQL Server
- Sql – How to return only the Date from a SQL Server DateTime datatype
- Sql-server – How to check if a column exists in a SQL Server table
- Sql-server – Check if table exists in SQL Server
- Sql – How to concatenate text from multiple rows into a single text string in SQL Server
- Mysql – Which MySQL data type to use for storing boolean values
- Sql – DateTime2 vs DateTime in SQL Server
- Sql – How to UPDATE from a SELECT in SQL Server
Best Answer
The equivalent is a
BIT
field.In
SQL
you use0
and1
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.