In the sql table, I have a bit field and the value is displayed as True, when I update the code Update table1 set Active='True' , it does the update, but the value is now displayed as 1 instead of True . How to make it put the value 'True' instead of an integer in the table? Thanks.
Update table1 set Active='True'
1
True
'True'
Bits in SQL Server are always saved as 1 or 0 in a bitmap.
Bits
0
The "Edit Table" parameter in SSMS simply converts this value to True or False for presentation purposes, it has nothing to do with how it is actually stored.
False