CASE statement is used to execute statements in different situations
Example1:
Update TableName
Set ComunName = Case
when Condition1 then do this
when Condition2 then do this
when Condition3 then do this
...........................
end
NB: The case can be applied in any statements that we want in different conditions. In the above example, The word 'Case' will be replace by 'do this' in which ever condition is satisfied.
Example1:
Update TableName
Set ComunName = Case
when Condition1 then do this
when Condition2 then do this
when Condition3 then do this
...........................
end
NB: The case can be applied in any statements that we want in different conditions. In the above example, The word 'Case' will be replace by 'do this' in which ever condition is satisfied.
No comments:
Post a Comment