title: Execute stored procedure with one parameter as an input
body: <p>I am using stored procedure. My stored procedure is </p>
  
  <pre><code>Create PROCEDURE [dbo].[SP_HouseHoldMembers]
  (
  @StudentID varchar
  )
  AS
  BEGIN
  SELECT MemberID,FirstName+''+LastName,Age,Sex,Education
  FROM Student SD 
  WHERE SD.StudentID=@StudentID
  END
  </code></pre>
  
  <p>I execute it like this: </p>
  
  <pre><code>EXEC [dbo].[SP_HouseHoldMembers] @StudentID='123'
  </code></pre>
  
  <p>BUT ITS NOT SHOWING THE RESULT AND WHEN I execute it simply by using simple query taking this <code>123</code> as an input then it gives the desired result.</p>
  
  <p>Please someone tell where i am going wrong</p>