SQL Update multiple rows in a single query

Question

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:

UPDATE PricePlan SET Price='" + GuestInput.Text + "' WHERE PricePlanName = 'Guest' THEN Price='" + MemberInput.Text + "' WHERE PricePlanName = 'Member'

please lookup 'SQL Injection" and parameterised queries.

Mitch Wheat
– Mitch Wheat

2011-02-13 06:46:09 +00:00
Commented Feb 13, 2011 at 6:46 — Mitch Wheat
– Mitch Wheat, Commented Feb 13, 2011 at 6:46

Whimsical · Accepted Answer · 2011-02-13 07:03:35Z

2

Something like this should work...you make have to modify it a little bit

"UPDATE PricePlan 
       SET price =
                 IIf(PricePlanName = 'Guest',"+ GuestInput.Text + ",
                   IIf(PricePlanName = 'Member',"+ MemberInput +"))"

edited Feb 13, 2011 at 7:03

answered Feb 13, 2011 at 6:43

Whimsical

6,3852 gold badges36 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

pacheco Over a year ago

received the following error: "Syntax error (missing operator) in query expression 'CASE WHEN (PricePlanName = 'Guest') THEN '3.00' WHEN (PricePlanName = 'Member' THEN '2.00' END'

Whimsical Over a year ago

@pacgeco IFF is synonymous to case in ms access...try now

pcofre Over a year ago

There's a missing parenthesis after 'member'. Try fixing it or just remove every paranthesis, in this case are unnecesary

Collectives™ on Stack Overflow

SQL Update multiple rows in a single query

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related