Like operator for date in sqlserver
create PROCEDURE sp_Delete_RehabilitationDtls
(
@EmpId VARCHAR(50), @RehabDt datetime
)
AS
declare @Dtdate varchar(50)
select @Dtdate=replace((convert(varchar, @RehabDt,107) +'%'),',','')
delete
FROM Pro_Emp_Rehabilitation_Dts where Emp_Id=@EmpId and RehabilitationDate like @Dtdate