Sql Server - Update Trigger

by Yugolancer

Posted on Thursday, April 5, 2018

CREATE TRIGGER [dbo].[ESR_INSERT]
   ON  [dbo].[Loan] FOR INSERT AS
UPDATE 
	Loan 
SET 
	ESR = '01' + ' ' + FORMAT(Loan.Id, '00000') + '...'
FROM 
	Loan
JOIN 
	Inserted 
ON 
	Inserted.Id = Loan.Id
WHERE 
	Loan.ESR IS NULL