Will update trigger call again and again when Update the same table?

I want to make update trigger. My doubt is, when I create trigger that will change the value of same table. So it will change again?

For example:

Table name is Item

ItemNo ItemName  cost SellPrice
101     xxx      10   12
102     xxx      12   17
103     xxx      15   19
104     xxx      17   20

by using update trigger I will change the cost into 99 when User update the cost.

So once it's updated into 99, will Update trigger call again?

1 answer