Thread: value of true/false in sql table

Results 1 to 3 of 3
Share This Thread →
  1. August 2nd, 2004, 07:41 AM #1
    tr333
    tr333 is offline Contributing User ASP Free Newbie (0 - 499 posts)
    Join Date
    Jul 2004
    Location
    Sydney, Australia
    Posts
    44
    Rep Power
    9

    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...
    Give Rep
  2. August 2nd, 2004, 12:08 PM #2
    selwonk's Avatar
    selwonk
    selwonk is offline Contributing User ASP Free Loyal (3000 - 3499 posts)
    Join Date
    Jun 2004
    Posts
    3,072
    Rep Power
    188
    Hi

    Probably bit (0/1)

    MK
    Give Rep
  3. August 2nd, 2004, 01:51 PM #3
    Memnoch's Avatar
    Memnoch
    Memnoch is offline Unholy Moderator ASP Free God (5000+ posts)
    Join Date
    Oct 2003
    Location
    In hell, where did you think?
    Posts
    12,026
    Rep Power
    657
    SQL Server uses a Bit data type (1/0) to represent True/False, Yes/No, On/Off.
    Give Rep
Share This Thread →
« Previous Thread | Next 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. SQL works in MS Access, doesn't work in ASP page?!SQL query-Access vs. ASP Page?
    By Moonshadow in forum Microsoft Access Help
    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