SQL Server 2000 database 'bit' type problem. [modified]
-
SQL Server 2000 database 'bit' type problem. --------------------------------------------- I haven't given any initial value of that field in design time For Ex. The current value of 'Active' field is : 0 Now, I'm fire a update query of other fields except 'Active' field. But, this query update the value of 'Active' field with 1. Means, I haven't use this 'Active' field in my Query. My Query is : update tblProduct set Name = 'xxxx' where ProductID = 1 but, After fire this query, My 'Active' fields value become 1, while it was 0. So, This is my problem. Hope you will get this now. Please, Help me as soon as possible. Thanks. -- modified at 1:41 Friday 14th September, 2007
Regards, Abhi
-
SQL Server 2000 database 'bit' type problem. --------------------------------------------- I haven't given any initial value of that field in design time For Ex. The current value of 'Active' field is : 0 Now, I'm fire a update query of other fields except 'Active' field. But, this query update the value of 'Active' field with 1. Means, I haven't use this 'Active' field in my Query. My Query is : update tblProduct set Name = 'xxxx' where ProductID = 1 but, After fire this query, My 'Active' fields value become 1, while it was 0. So, This is my problem. Hope you will get this now. Please, Help me as soon as possible. Thanks. -- modified at 1:41 Friday 14th September, 2007
Regards, Abhi