I have a Bit field in my database ,but when i try to insert the bit in database it inserted succesfully but while accessing it returns -1,what would be the problem?
i used integer while inserting same as get the value from database?
In SQL Server Bit data can only be one of the 3 values: 1, 0, or Null. So I'm wondering how did you get the returned value -1. What's the returned value if you directly query the database (in Query Analyzer or Enterprise Manager, or using OSQL utility)? And could you please post the code for retrieving the bit data from database?
No comments:
Post a Comment