title: SQL Update multiple rows in a single query
body: <p>If let's say i would like to update 2 or more rows in a single SQL query, how can i do that? My current statement which is not working are as follows:</p>
  
  <p><code>UPDATE PricePlan SET Price='" + GuestInput.Text + "' WHERE PricePlanName = 'Guest' THEN Price='" + MemberInput.Text + "' WHERE PricePlanName = 'Member'</code></p>