SQL - CREATE TRIGGER - SOLUCION DE ACTUALIZACIÓN

 

un poco de informacion sobre trigger:

https://learn.microsoft.com/es-es/sql/t-sql/statements/create-trigger-transact-sql?redirectedfrom=MSDN&view=sql-server-ver16

y el codigo del trigger que se uso:

CREATE TRIGGER [dbo].[tr_updateUpper]

ON [dbo].[Customer]

AFTER INSERT

AS

BEGIN

  UPDATE Customer

  SET AccountNumber = UPPER(AccountNumber)

  WHERE AccountNumber = (SELECT AccountNumber FROM inserted)

END

GO