Wednesday, November 21, 2012

Single Line Query for Update all Records using Case Statement

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

No comments:

Post a Comment