Stored Procedure for Searching

[gopi2ks]

Dear All,
I have one table

eg: Employee (Table Name)
Fields (Columns)

Eno,Ename,Dept,Designation,Date of Birth,PhNumber, City
Some are not nulls and some are nulls

I need to write a Stored Procedure to search by all the fields.
or What ever the user entered in all the fields like that it has to search

How to write the Stored procedure to do best performance in searching

Thanks in Advance

[deepuv04]

Dear All,
I have one table

eg: Employee (Table Name)
Fields (Columns)

Eno,Ename,Dept,Designation,Date of Birth,PhNumber, City
Some are not nulls and some are nulls

I need to write a Stored Procedure to search by all the fields.
or What ever the user entered in all the fields like that it has to search

How to write the Stored procedure to do best performance in searching

Thanks in Advance

Hi,
Here is the sample code, add the columns or parameters as per your requirement.

[code = sql]
CREATE PROCEDURE EmployeeSearch(
@ENO int = NULL,
@Ename varchar(100) = NULL,
@Designation varchar(100) = NULL
) AS
BEGIN

SELECT Eno,Ename,Dept,Designation,Date of Birth,PhNumber, City
FROM Employee
WHERE Eno = ISNULL(@ENO,Eno) AND
Ename = ISNULL(@Ename,Ename) AND
Designation = ISNULL(@Designation,Designation)
END


[/code]
Thanks