sql - How do I use an IF type structure in an UPDATE statement? -

sql - How do I use an IF type structure in an UPDATE statement? -

in t-sql can utilize case statement when doing select determine sort of info want return. i'd that, not in select statement, instead in update statement. don't know if right format or not, you'll thought this.

here's i'm trying do:

create procedure spsomeps @number1 int, @number2 int, @amt money begin upate sometable case @number1 +1 = @number2 moneycolumn = moneycolumn - @amt else moneycolumn = moneycolumn + @amt end -- end case statement

will i'm trying or there syntax?

you can utilize case look in update statement in select statement.

create procedure spsomeps @number1 int, @number2 int, @amt money begin upate sometable set moneycolumn = case when @number1 +1 = @number2 moneycolumn - @amt else moneycolumn + @amt end -- end case statement

sql sql-server sql-update