date time convert

Question

I want to get result of below query in sp

 

select * from Policy_Holder_Details where Pan_Number='CQVPB1111M' and Date_Of_Birth='14-Jun-1992'

 

result:-

 

 

but I Execute below sp then not get in result

 

ALTER PROCEDURE [dbo].[GetLoginByIdentifyPasswordDOB]

-- Add the parameters for the stored procedure here

@Identify varchar(50) ,

@Password varchar(50) ,

@Date_Of_Birth Datetime

AS

BEGIN

-- SET NOCOUNT ON added to prevent extra result sets from

-- interfering with SELECT statements.

SET NOCOUNT ON;

select * from Policy_Holder_Details where @Identify=@Password and Date_Of_Birth = @Date_Of_Birth

END