Is there a Boolean data type in Microsoft SQL Server like there is in MySQL?

sql-server types boolean
TinTin picture TinTin · Jun 29, 2010 · Viewed 751.2k times · Source

Is there a Boolean data type in Microsoft SQL Server like there is in MySQL?

If so, what is the alternative in MS SQL Server?

Answer

kristian picture kristian · Jun 29, 2010

You could use the BIT datatype to represent boolean data. A BIT field's value is either 1, 0, or null.

Related questions

Difference between numeric, float and decimal in SQL Server

What are the differences between numeric, float and decimal datatypes and which should be used in which situations? For any kind of financial transaction (e.g. for salary field), which one is preferred and why?

Read More
How to store decimal values in SQL Server?

I'm trying to figure out decimal data type of a column in the SQL Server. I need to be able to store values like 15.5, 26.9, 24.7, 9.8, etc I assigned decimal(18, 0) to the column data type but this not allowing me to store …

Read More
Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?

I'm curious as to whether or not there is a real difference between the money datatype and something like decimal(19,4) (which is what money uses internally, I believe). I'm aware that money is specific to SQL Server. I want to …

Read More