Cacher is the code snippet organizer for pro developers

CREATE TRIGGER CEFP.trg_RepairLog_Insert
ON CEFP.CEFPRepairLog
AFTER INSERT
AS
BEGIN
	DECLARE @csNumber varchar(50)
	DECLARE @id AS int

	SELECT @id = RepairLogID FROM INSERTED
	SET @csNumber = CAST(YEAR(GETDATE()) AS varchar) + '-' + CAST(@id AS varchar)
	UPDATE CEFP.CEFPRepairLog SET CaseNumber = @csNumber
END