SQLTeam.com | Weblogs | Forums

Update a salary by 500


#1

i have a table which consist of salary column having salary 200, 300, 400, null i have to update a salary by 500 such that output will become 700, 800, 900 ,500


#2

update table set salary=isnull(salary,0)+500


#3

i believe when there is no salary you should not update the value to 500 hence the query should be.

update table set salary=salary+500