Click here to Skip to main content
15,914,608 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi everybody,
i am a new user in code project. please help me for finding the above answer .
thank you
Posted
Comments
Varun Sareen 25-Feb-12 0:18am    
what is your requirement? can you please state it?
pradeep kumar tarei 25-Feb-12 0:42am    
thankx varun
Varun Sareen 25-Feb-12 1:34am    
your welcome pradeep..Please don't forget to rate the answer also :)

1 solution

Yes you can dear friend, Take an example of a stored procedure with only one out parameter. In this you can send the input to the stored procedure and set the value of the same parameter in order to return he value.

For E.g.:-
CREATE PROCEDURE GetEmployeeType
   @employeeTypeOrName varchar(80) OUTPUT
AS
BEGIN
   SELECT employeeTypeOrName = EmployeeType
   FROM HumanResources.Employee
   WHERE EmployeeName Like '%employeeTypeOrName%'
END


Please don't forget to mark this as your answer if it helps you out.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900