Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Slovakia
    Posts
    32

    Question Unanswered: boolean data type

    What data type should I use as a replacement of Boolean in SQL server? I need to create a table column with a "two-state" data type and must ensure, that only one record can hold value "True" in this column... Any ideas?

    Thanks
    (sz)Tomi

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    You could use the bit datatype for this purpose. If the bit is always defined I think it even may save some space. However, if there are (possibly in the future) some procedures or external programs involved I'd stick to using int instead.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •