Question

Delphi 判断SQL数据库某字段的值大于0 或不为NULL时，执行对数据库的UPDATA

Delphi 判断SQL数据库某字段的值大于0 或不为NULL时，执行对数据库的UPDATA

就是 怎样在 Select * from UserBasicInfo where (BedchamberId > 0 and BedchamberId is NUll) 的情况下 才 执行

'Update UserBasicInfo set UserName=Rtrim(t1.UserName), GenderId=t1.Gender, ExtUserId=t1.ExtUserId, CardId=case when UserType<>3 or UserType is null then t1.CardId else t2.CardId end, CridentialId=t1.CridentialId, ExpiredTime=t1.ExpiredTime,IdentityNO=t1.IdentityNo,EmployeeType=t3.Id ,EmpDeptId=t4.Id ,WorkPosition=t1.PositionId from UserBasicInfo t2 left join temInputUser t1 on t1.CridentialId=t2.CridentialId left join Dict_EmployeeType t3 on t1.EmployeeType=t3.Name left join DeptBranch t4 on t1.DeptName=t4.Name where t2.CridentialId in (select CridentialId from temInputUser) , '

如果 BedchamberId 为空 就不进行更新

这个判断具体要怎么写啊？求指点啊 谢谢

Answer 1

不为null或大于零这个条件只需要判断是否null就可以了因为大于零的肯定不为null

where (BedchamberId > 0 and BedchamberId is NUll),这是大于零 且 不为null，此条件可转换为
where isnull(BedchamberId,0)>0
where BedchamberId Is not null 这是大于零 或 不为null

Answer 2

update UserBasicInfo ubi set ... where （ubi.BedchamberId > 0 and ubi.BedchamberId is NUll）