Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read SiteMap

Tags: , , ,

Sponsored Links



Store default boolean value in SQL server

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 09-06-2009
Member
 
Join Date: Feb 2009
Posts: 42
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
Reply With Quote
  #2  
Old 09-06-2009
MindSpace's Avatar
Member
 
Join Date: Feb 2008
Posts: 1,832
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).
Reply With Quote
  #3  
Old 09-06-2009
Modifier's Avatar
Member
 
Join Date: Jan 2008
Posts: 1,502
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.
Reply With Quote
Reply

  TechArena Community > Software > Software Development


Thread Tools Search this Thread
Search this Thread:

Advanced Search


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


All times are GMT +5.5. The time now is 12:08 PM.