帮忙写一个SQL语句 if @Flag=0
BEGIN
Update TBL
Set chkTime = case when ISNULL (chkFlag,0)= 1then NULL else @nowdate end,
FROM TBLINNER JOIN TBL2
ON TBL.id= TBL2.id
Where TBLcusID =@CustomerID
END上面这个语句中,希望在chkTime = NULL的时候,赋值 case when ISNULL (chkFlag,0)= 1then NULL else @nowdate end,
否则保持chkTime 值不变!
BEGIN
Update TBL
Set chkTime = case when ISNULL (chkFlag,0)= 1then NULL else @nowdate end,
FROM TBLINNER JOIN TBL2
ON TBL.id= TBL2.id
Where TBLcusID =@CustomerID
END上面这个语句中,希望在chkTime = NULL的时候,赋值 case when ISNULL (chkFlag,0)= 1then NULL else @nowdate end,
否则保持chkTime 值不变!
if @Flag=0
BEGIN
Update TBL
Set chkTime = case when ISNULL (chkFlag,0)= 1then NULL else @nowdate end,
FROM TBLINNER JOIN TBL2
ON TBL.id= TBL2.id
Where TBLcusID =@CustomerID and chkTime is null
END