hie everyone,
I want to store the default boolean value in my SQL server. Can anybody please suggest me in SQL server what is the default value of the boolean parameter and how can I store the same ?
thank you
hie everyone,
I want to store the default boolean value in my SQL server. Can anybody please suggest me in SQL server what is the default value of the boolean parameter and how can I store the same ?
thank you
Boolean variables are stored as 16-bit (2-byte) numbers, which can only be represented or assigned as either one of the two following states - True or False.
Note - Boolean variables display as
either True or False (when Print is used)
#TRUE# or #FALSE# (when Write # is used).
The default Boolean values are 0 (for false) and values other than 0(for true).
Look, in SQL Server, there is no boolean data type. However, the closest data type that can be used in place of boolean data is the BIT data type. The BIT datatype is an integer data type that can accept a value of 1, 0 or NULL value only.
Bookmarks