Wednesday 16 October 2013

06. Create a trigger named Emp_Update on the EmployeeDetail table. This trigger should restrict a user from performing any kind of DML operation on the table before 9 A.M and after 5 P.M.

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

No comments:

Post a Comment