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

Reply
 
Thread Tools Search this Thread
  #1  
Old 09-06-2009
Member
 
Join Date: Feb 2009
Posts: 56
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
Member
 
Join Date: Feb 2008
Posts: 1,848
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
Member
 
Join Date: Jan 2008
Posts: 1,515
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
Tags: , , ,



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
OS X Lion Server is not appearing in App Store even after buying it Rakshasa Networking & Security 6 24-04-2012 02:38 AM
Cannot open your default email folders. Information store could not be opened - error message Jaiya Windows Software 10 11-04-2012 02:34 PM
Samsung App Store server is always down Tristyn Portable Devices 6 02-09-2011 10:57 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


All times are GMT +5.5. The time now is 03:26 PM.