Yes /No field

[Mini]

I would like to create a table with the attribute send (in Access you can check the option yes or no). Now I would like to write this field in sql. How can I do it? Boolean?

For ex..

CREATE TABLE ID_BLA(
ID_B NUMBER,
DATE_B DATE,
SEND ?

 

[Antero360]

I would like to create a table with the attribute send (in Access you can check the option yes or no). Now I would like to write this field in sql. How can I do it? Boolean?

For ex..

CREATE TABLE ID_BLA(
ID_B NUMBER,
DATE_B DATE,
SEND ?

Hi there,
Yup, boolean does the trick.. you can set it to TRUE (1) or FALSE (0)

 

[Mini]

Hi there,
Yup, boolean does the trick.. you can set it to TRUE (1) or FALSE (0)

I'm trying to use boolean in ssms 20 but it's not working. I'm making a mistake somewhere. Any tips for a newbie?

 

[Johna]

I think some databases might not directly support a Boolean datatype, but a simple number data type with 1 for true and 0 for false should do the trick.

 

[Wizibon]

The best is to not use tables in Y/N-Questions?

 

[Antero360]

For MSSQL Server, you can use the bit datatype, which is the corresponding for boolean

 

[Zakwan@MTH]

I would like to create a table with the attribute send (in Access you can check the option yes or no). Now I would like to write this field in sql. How can I do it? Boolean?

For ex..

CREATE TABLE ID_BLA(
ID_B NUMBER,
DATE_B DATE,
SEND ?

you can use boolean data type for your send attribute which takes the values true or false which represent yes and no respectively