var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Sql Server Datatype
I have a access table that I need to create in SQL Server, there are field with yes/no, in sql server what datatype would I use?
Bit datatype will be suitable for this field.Bit can store 0,1 or null.
Originally Posted by milan1115
You can store yes for 1,and no for 0.
if you use the bin data type you can set it to NOT NULL which will limit to 0 or 1.
Alternatively you can use data type such as int, or char(1) and use constraints to limit the value to 'Y' or 'N'.