USE DATABASE
GO

UPDATE tablename
    SET columnname= value
    
IF @@ERROR = 547
    PRINT N'A check constraint violation occurred.';
GO