SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE sales
(id INT PRIMARY KEY IDENTITY, name VARCHAR(30),
percent_part FLOAT, sales FLOAT, sum_bonus AS (sales * percent_part / 100));

INSERT INTO sales (name, percent_part, sales)
VALUES('staff1', 7.0, 7088), ('staff2', 3.5, 20590), ('staff3', 10.5, 6089);
3 rows affected

SELECT *
FROM sales;


id
name
percent_part
sales
sum_bonus


1
staff1
7
7088
496.16

2
staff2
3.5
20590
720.65

3
staff3
10.5
6089
639.345


UPDATE sales SET sales = 7150 WHERE id=1;
1 rows affected

SELECT *
FROM sales;


id
name
percent_part
sales
sum_bonus


1
staff1
7
7150
500.5

2
staff2
3.5
20590
720.65

3
staff3
10.5
6089
639.345

id	name	percent_part	sales	sum_bonus
1	staff1	7	7088	496.16
2	staff2	3.5	20590	720.65
3	staff3	10.5	6089	639.345

id	name	percent_part	sales	sum_bonus
1	staff1	7	7150	500.5
2	staff2	3.5	20590	720.65
3	staff3	10.5	6089	639.345