1、SQL Server 7中有布尔类型,叫做“Bit”,但数值为1和0,不是True Or False
2、SqlStr1 = "Select * From Table Where ifa = 1"
SqlStr2 = "Update Table Set ifa = 1 Where ……"
比如说,
If ifa = True Then SqlStr2 = "Update Table Set ifa = 1 Where ……"
Else SqlStr2 = "Update Table Set ifa = 0 Where ……"
End If
2、SqlStr1 = "Select * From Table Where ifa = 1"
SqlStr2 = "Update Table Set ifa = 1 Where ……"
比如说,
If ifa = True Then SqlStr2 = "Update Table Set ifa = 1 Where ……"
Else SqlStr2 = "Update Table Set ifa = 0 Where ……"
End If
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货