What is the difference between BIT and Boolean , Why we can use Boolean in SQL Server 2017

Question

What is the Difference between Bit and Boolean?

Why can't we use boolean in SQL Server 2017.

I tried to use bool in SQL query it showing error.

"*Why can't we use boolean in SQL Server 2017?"* - SQL Server simply does not support the standard `boolean` data type. — a_horse_with_no_name, Aug 12 '19 at 07:15

score 3 · Accepted Answer · answered Aug 12 '19 at 07:13

3

There is no boolean in SQL Server. Instead it uses BIT type to store 0 or 1.

You can refer this for more info

answered Aug 12 '19 at 07:13

1

This should have been a close as dupe vote instead of an answer. – Zohar Peled Aug 12 '19 at 07:49

1 Answers1