Regarding stored procedure help me

[chinni1]

Hi
I want to know how to write storedprocedure when search creiteria is Present.

Here the query to give the list of

"select ID, Salesmennummer , Salesname Commision, Areacode from sales_master

Areacode Salesmennummer Salesname Commision
1 1000 Rams 200
2 2000 Johny 1000


I Want to search above list by areacode or Salesmennummer or Salesname.

so PlZ help me how to write storedprocedure for this.

Thanq.

[ammoos]

Create procedure [OWNER].[PROCEDURE NAME]
@areacode integer
as
begin
select ID, Salesmennummer , Salesname Commision, Areacode from sales_master
where Areacode=@areacode
end

GO

[chinni1]

Thanq for ur reply .I tried like

CREATE PROCEDURE [dbo].[salesearch]

@sales_code int,
@sales_name varchar(50),
@area_code int
AS

set nocount on;
select sales_code,sales_name,area_code from sales where sales_code=@sales_code and sales_name=@sales_name
and area_code=@area_code
GO


but i got err like" Procedure 'salesearch' expects parameter '@sales_code', which was not supplied."
what it mean
Thanq

[gpl]

It means that you have not provided all 3 parameters when you ran it

[chinni1]

Iam new to storedprocedures will u tell me hw to provide parameters

[dafodil]

Different languages have different ways of passing parameters to SQL stored procedures. Try to read this and view the other links connected to this site:
http://msdn.microsoft.com/en-us/library/ms190669.aspx

Heres about parameters:
http://msdn.microsoft.com/en-us/library/ms189260.aspx