|
| |||||||||
| Tags: boolean value, default, sql server, store |
![]() |
| | Thread Tools | Search this Thread |
|
#1
| |||
| |||
| Store default boolean value in SQL server
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 |
|
#2
| ||||
| ||||
| Re: Store default boolean value in SQL server
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). |
|
#3
| ||||
| ||||
| Re: Store default boolean value in SQL server
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. |
![]() |
|
| Thread Tools | Search this Thread |
| |
Similar Threads for: "Store default boolean value in SQL server" | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Samsung App Store server is always down | Tristyn | Portable Devices | 6 | 02-09-2011 11:57 AM |
| Cannot open your default email folders. Information store could not be opened - error message | Jaiya | Windows Software | 5 | 17-04-2011 09:42 AM |
| Problem in boolean function | Luis-Fernando | Software Development | 4 | 08-02-2010 08:02 PM |
| How to check the value of boolean variable | Amie | Software Development | 4 | 26-11-2009 06:29 PM |
| Default mailbox store | Nick van Ogtrop-de Ruiter | Small Business Server | 5 | 06-12-2008 01:01 AM |