Select all the record from Database Table if parameter is null in SQL Server

Mahesh19...

SOLVED CLOSED ACTIVE ANSWERED
User: Mahesh1986
Posted: on Jul 27, 2017 06:20 AM
Forum: SQL Server
Answer: 1
Views: 2813

i have a table employee with calumns

EmpID,Name,Gender

i need a stored procedure where we have to pass parameter gender value

if we dont pass parameter it should execute like select * from table name

if we pass gender value it should execute like select 8 from tablename where gender=value

Download FREE API for Word, Excel and PDF in ASP.Net

itsjaysh...

0 2

Reply
User: itsjayshah
Replied: on Jul 28, 2017 06:53 AM
Report

CREATE PROCEDURE Employee_GetDetailsBasedonGender
@Eid int=0,
@Name nvarchar =null,
@Gender int=0,
@status varchar(max)
As
Begin

if @status='gender_selected'
begin
SELECT * FROM  Employee WHERE Gender = @Gender
end

if @status='all_records'
begin
SELECT * FROM  Employee
end
end

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Select all the record from Database Table if parameter is null in SQL Server

Company

Explore

Follow us

Contact Us