Click here to Skip to main content
13,052,494 members (73,341 online)
Rate this:
Please Sign up or sign in to vote.
Hi Friends:

I am new to SQL and trying write stored proc. I am having some difficulties to get default values as an output result.
I have 2 table:
InputID	SectionID  ParameterName    Sequence
1	100	   FirstName	        1 
2	100	   MiddleName	        2  
3	100	   LastName	        3  
ParameterName	ParameterValue      DefaultValue
FirstName	John	   	        1    
FirstName	Troy	                0
FirstName	Mark	   	        0  

I am trying to call ParameterName from Student_Input and Its default value from Student_Input_Details as an output in one table. I am trying with following query but I am getting following error:
Msg 201, Level 16, State 4, Procedure Getparameterdefaultvalues, Line 0
Procedure or function 'Getparameterdefaultvalues' expects parameter '@ParameterValue', which was not supplied.

I am sure I am missing something important here.
Create Procedure Getparameterdefaultvalues
@ParameterName varchar(50) ,
@ParameterValue varchar(50) out
Select @ParameterValue = DefaultValue from Student_Input_details where ParameterName=@ParameterName
Execute Getparameterdefaultvalues 1

I need result like (i.e. ParameterName should only display its default value at runtime):
ParameterName	ParameterValue      
FirstName	John
Apologies If my question is not so cleared. Any help would be grate!! Thx :)
Posted 12-Dec-12 6:11am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Although I am not sure, that this is a good concept, the error message is caused by wrong syntax.
You call the stored procedure with only a single parameter. But where do you think your output parameter will be put? In the void? No. You have to give a variable to be filled with the output parameter. Check out here:[^]

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 12 Dec 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100