Click here to Skip to main content
Rate this: bad
good
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:
 
1)Student_Input:
 
InputID	SectionID  ParameterName    Sequence
 
1	100	   FirstName	        1 
        
2	100	   MiddleName	        2  
       
3	100	   LastName	        3  
 
2)Student_Input_details:
 
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
)
As
Begin
Select @ParameterValue = DefaultValue from Student_Input_details where ParameterName=@ParameterName
End
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 Smile | :)
Posted 12-Dec-12 7:11am
Joy1979316

1 solution

Rate this: bad
good
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: http://msdn.microsoft.com/en-us/library/ms187004(v=sql.105).aspx[^]
  Permalink  
v2

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 535
1 OriginalGriff 275
2 BillWoodruff 260
3 Shweta N Mishra 244
4 Deepu S Nair 230
0 OriginalGriff 6,168
1 Sergey Alexandrovich Kryukov 5,818
2 DamithSL 4,958
3 Manas Bhardwaj 4,539
4 Maciej Los 3,755


Advertise | Privacy | Mobile
Web02 | 2.8.1411019.1 | Last Updated 12 Dec 2012
Copyright © CodeProject, 1999-2014
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