Notices

Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

Thread: value of true/false in sql table

Results 1 to 3 of 3
Share This Thread →
  1. #1
    tr333 is offline Contributing User
    Join Date
    Jul 2004
    Location
    Sydney, Australia
    Posts
    44
    Rep Power
    10

    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
    selwonk's Avatar
    selwonk is offline Contributing User
    Join Date
    Jun 2004
    Posts
    3,072
    Rep Power
    189
    Hi

    Probably bit (0/1)

    MK

  3. #3
    Memnoch's Avatar
    Memnoch is offline Unholy Moderator
    Join Date
    Oct 2003
    Location
    In hell, where did you think?
    Posts
    12,026
    Rep Power
    658
    SQL Server uses a Bit data type (1/0) to represent True/False, Yes/No, On/Off.

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

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, 02:54 AM
  2. SQL Statement Case selection...
    By plasma800 in forum SQL Development
    Replies: 1
    Last Post: May 4th, 2004, 05:13 AM
  3. Replies: 8
    Last Post: March 26th, 2004, 10:23 AM
  4. insert query
    By jamesjohn in forum ASP Development
    Replies: 1
    Last Post: March 17th, 2004, 11:36 PM
  5. search help
    By dev5 in forum ASP Development
    Replies: 18
    Last Post: March 5th, 2004, 10:07 AM

ASP Free Advertisers and Affiliates