How to implement "If condition in stored procedure" ?

You can find in below code, How "if condition" is implemented.

IF EXISTS (SELECT * FROM SYSOBJECTS WHERE OBJECT_ID=('GetProjectList'))
DROP GetProjectList
GO

CREATE PROCEDURE GetProjectList
(
@psStatus VARCHAR(20)
)
AS
BEGIN
IF @psStatus=' '
BEGIN
SELECT PRO.*,CUST.CustomerName,CAT.CategoryName FROM Projects PRO,CUSTOMER CUST,PROJECTCATEGORY CAT WHERE PRO.CustomerID=CUST.CustomerID AND CAT.CategoryID=PRO.ProjectCategory
END
ELSE
BEGIN
IF @psStatus='Open'
SELECT PRO.*,CUST.CustomerName,CAT.CategoryName FROM Projects PRO,CUSTOMER CUST,PROJECTCATEGORY CAT Where Status='Open' AND PRO.CustomerID=CUST.CustomerID AND CAT.CategoryID=PRO.ProjectCategory
ELSE
SELECT PRO.*,CUST.CustomerName,CAT.CategoryName FROM Projects PRO,CUSTOMER CUST,PROJECTCATEGORY CAT Where Status='Close' AND PRO.CustomerID=CUST.CustomerID AND CAT.CategoryID=PRO.ProjectCategory
END
END
GO

Hope this post will help you,
Rajesh Singh
Asp.Net Developer
Indianic Infotech Ltd (India)
Rajesh@indianic.com