October 19th, 2006, 12:38 AM
|
|
Registered User
|
|
Join Date: Oct 2006
Posts: 1
Time spent in forums: 26 m 52 sec
Reputation Power: 0
|
|
BIT datatype handling in SQL Server 2000
I'm using SQL Server 2000 and I have a column field with a data type of BIT on my database. Its default value is 0. I have a VB6 application program that I used to access my database. After running the program, I noticed that the value of this particular field has been changed to 1. I tried debugging my code but did not find any syntax that alters the value of this field.
Does it have something to do with the SQL Service Pack? My SQL Server 2000 has been applied with SP2.
Thank you very much in advance.
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
