ALTER TRIGGER [dbo].[TRG_TEST_CheckName] ON [dbo].[TEST] AFTER INSERT,UPDATE AS BEGIN SET NOCOUNT ON; IF EXISTS (SELECT NOM from inserted where (LEN(NOM) > 5)) BEGIN RAISERROR ('Le champ NOM ne peut excéder 5 caractères', 16, 1); ROLLBACK TRANSACTION; END END