Thursday 8 October 2015

Update mutiple rows using single statement

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