SQL Server 2017

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

CREATE TABLE Product(id INT PRIMARY KEY, description VARCHAR(100), currentStock INT)
CREATE TRIGGER T9 ON Product INSTEAD OF UPDATE
AS 
UPDATE p
SET description = i.description
FROM Product p
JOIN inserted i
  ON p.id = i.id;
INSERT INTO Product VALUES(1, 'ProductA', 100);
1 rows affected

SELECT * FROM Product;


id
description
currentStock


1
ProductA
100


UPDATE Product
SET description = 'Product B'
    ,currentStock = 200
WHERE id = 1;
2 rows affected

SELECT * FROM Product;


id
description
currentStock


1
Product B
100