There is an issue with the bit type display in MSSQL

[929496959]

As shown in the picture, the right side is normal, while the left side is incorrect
左边的是显示错误的,右边的是正常的,都是同一条数据.

[929496959]

The normal values should be 1 and 0

[929496959]

The delete command did not restore SQL
执行了删除指令,没有还原sql

[929496959]

我的估计是把bit当做char类型处理了导致的.查询的时候强制转为char 就是正常显示