create procedure procedurename ( @id varchar(6) //parameters ) as begin select * from custinfo where cust id=@id //Your's query end To execute the procedure exec procedurename '2'//parameter value
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)