Results 1 to 3 of 3

Thread: Store default boolean value in SQL server

  1. #1
    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

  2. #2
    Join Date
    Feb 2008
    Posts
    1,852

    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. #3
    Join Date
    Jan 2008
    Posts
    1,521

    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.

Similar Threads

  1. OS X Lion Server is not appearing in App Store even after buying it
    By Rakshasa in forum Networking & Security
    Replies: 6
    Last Post: 24-04-2012, 02:38 AM
  2. Replies: 10
    Last Post: 11-04-2012, 02:34 PM
  3. Samsung App Store server is always down
    By Tristyn in forum Portable Devices
    Replies: 6
    Last Post: 02-09-2011, 10:57 AM
  4. Problem in boolean function
    By Luis-Fernando in forum Software Development
    Replies: 4
    Last Post: 08-02-2010, 08:02 PM
  5. How to check the value of boolean variable
    By Amie in forum Software Development
    Replies: 4
    Last Post: 26-11-2009, 06:29 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,717,759,273.85646 seconds with 17 queries