Column Value Restriction - Trigger

To restrict the column value change beyond the range, you may consider to use the below trigger in sql server.

CREATE TRIGGERTrig_column_value_Restriction on schedule for Insert, Update as
Begin
Declare @TimeType int, @day int, @HOUR int,@MINUTE int
select @TimeType = TimeType,@day=day, @HOUR=HOUR,@MINUTE=MINUTE from Inserted
if (@TimeType = 2 and ( @day NOT BETWEEN 0 and 31 OR @HOUR NOT BETWEEN 0 and 23 OR @MINUTE NOT BETWEEN 0 AND 59 ) )
Begin
RaisError('PLEAE TYPE DAY, HOUR, MINUTE WITHIN THE RANGE. PLEASE CONTACT ADMINISTRATOR IF YOU NEED ANY HELP', 18, 1)
Rollback Tran
End
End

To see the available trigger in particular table:
sp_helptrigger 'TableName'
To enable or disable trigger for particular table:
DISABLE TRIGGER TRIGGERNAME ON TABLENAME;
ENABLE TRIGGER TRIGGERNAME ON TABLENAME;
To alter trigger:
Replace 'Create' with 'Alter' in above Trigger statement. It will alter.
To drop trigger:
DROP TRIGGER TRIGGERNAME