update tblCreditCardConvertTypes set IsDefault=(case when IsDefault =1 then 0 else 1 end)
OR
update tblCreditCardConvertTypes set IsDefault=0 update tblCreditCardConvertTypes set IsDefault ='True'
where ConvertID=6
OR
update tblCreditCardConvertTypes set IsDefault=0 update tblCreditCardConvertTypes set IsDefault ='True'
where ConvertID=6
No comments:
Post a Comment