#1
  1. No Profile Picture
    Contributing User
    ASP Explorer (0 - 99 posts)

    Join Date
    Jul 2004
    Location
    Sydney, Australia
    Posts
    44
    Rep Power
    11

    value of true/false in sql table


    what values does sql store for true/false in a table?

    msAccess stores it as yes/no, but i'm not sure about sql...
  2. #2
  3. Contributing User
    ASP Scholar (3000 - 3499 posts)

    Join Date
    Jun 2004
    Posts
    3,072
    Rep Power
    190
    Hi

    Probably bit (0/1)

    MK
  4. #3
  5. Unholy Moderator
    ASP Mastermind (5000+ posts)

    Join Date
    Oct 2003
    Location
    In hell, where did you think?
    Posts
    12,026
    Rep Power
    659
    SQL Server uses a Bit data type (1/0) to represent True/False, Yes/No, On/Off.

Similar Threads

  1. Cannot establish a connection to SQL Server 2K sp3a remotely
    By ngandy in forum Microsoft SQL Server
    Replies: 6
    Last Post: January 19th, 2005, 03:54 AM
  2. SQL Statement Case selection...
    By plasma800 in forum SQL Development
    Replies: 1
    Last Post: May 4th, 2004, 06:13 AM
  3. Replies: 8
    Last Post: March 26th, 2004, 11:23 AM
  4. insert query
    By jamesjohn in forum ASP Development
    Replies: 1
    Last Post: March 18th, 2004, 12:36 AM
  5. search help
    By dev5 in forum ASP Development
    Replies: 18
    Last Post: March 5th, 2004, 11:07 AM

IMN logo majestic logo threadwatch logo seochat tools logo