Results 1 to 3 of 3

Thread: Inserting a bit field in SQL Server

  1. Sep 26th, 2003, 03:05 PM #1
    hellswraith
    hellswraith is offline

    Thread Starter
    PowerPoster hellswraith's Avatar
    Join Date
    Jul 2002
    Location
    Washington St.
    Posts
    2,464

    Inserting a bit field in SQL Server

    How do you insert a bit field into a SQL Server database. Shouldn't I be able to use a boolean variable passing it to the stored procedure, and it should convert it...right?
    My Site
    Reply With Quote Reply With Quote
  2. Sep 26th, 2003, 03:07 PM #2
    Memnoch1207
    Memnoch1207 is offline
    Frenzied Member Memnoch1207's Avatar
    Join Date
    Feb 2002
    Location
    DUH, Guess...Hint: It's really hot!
    Posts
    1,861
    The bit field takes a 1 or 0 as the value, but returns a True or False.
    Being educated does not make you intelligent.

    Need a weekend getaway??? Come Visit
    Reply With Quote Reply With Quote
  3. Sep 26th, 2003, 07:21 PM #3
    hellswraith
    hellswraith is offline

    Thread Starter
    PowerPoster hellswraith's Avatar
    Join Date
    Jul 2002
    Location
    Washington St.
    Posts
    2,464
    Thanks, that was what I was thinking. I actually found out that the table I was inserting on had a trigger that disallowed the insert, so it probably wasn't anything I was doing.
    My Site
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width