i have used triger on table.This triger is fire when i insert data in LeaveFrom Table.In My Stored procedure if condition i have put.when i put if condition code in if condition is not working.If i remove if codition then insert work successfully.My I have try this code in Query builder.data is comming when if is fire.but what is problem in storeprocedure code,that i dont know.
My Triger is:
ALTER TRIGGER Trigger2
ON dbo.LeaveForm
AFTER INSERT
AS
Begin
EXEC Biometrics_InsertFrom_LeaveForm
End
My Storeprocedure is..
ALTER PROCEDURE dbo.Biometrics_InsertFrom_LeaveForm
AS
Declare @Count int
Declare @LeaveFrom datetime
Declare @LeaveTo datetime
Declare @Approve bit
set @Approve='True'
select @Count=count(*) from LeaveForm where Approve=@Approve and (convert(varchar,@LeaveFrom,101)=convert(varchar,getdate(),101) or convert(varchar,@LeaveTo,101)=convert(varchar,getdate(),101))
if(@Count > 0)
begin
INSERT INTO Biometrics (PCL,PLE)
VALUES (getdate(),getdate())
end
RETURN