Q 1.How to update mutiple rows using single statement.
Suppose we want to update M as Male and F as Female in Gender Table using single Sql Statement then we use
UPDATE Gender
set GenType = CASE GenType WHEN 'F' THEN 'Female' WHEN 'M' THEN 'Male'ELSE 'Unknown' END
No comments:
Post a Comment