create trigger emp_UPdate
on employeeDetail After insert, UpDATE, Delete
as
Begin
Declare @Time INT
set @Time=DateName (HH,GETDATE())
if @Time not Between 9 and 17
Begin
Rollback
print ('The operation cannot be performed')
end
end
on employeeDetail After insert, UpDATE, Delete
as
Begin
Declare @Time INT
set @Time=DateName (HH,GETDATE())
if @Time not Between 9 and 17
Begin
Rollback
print ('The operation cannot be performed')
end
end
No comments:
Post a Comment