Stored Procedure Parameters

  • Thread starter Thread starter caseyoconnor2
  • Start date Start date
C

caseyoconnor2

What are they for?
Why do we have to match them inside our C# or VB code?
Are they so the end user can input a value to query on?
When do we have to use them in C# and the SQL Server Stored Procedure
 
You are right - they are there for passing parameters to the stored
procedure. You need to pass it from your client code if you want to
execute the stored procedure (and if the stored procedure needs
parameter(s) ). Calling them, passing the parameters and getting the
result back from it is very straightforward thru ADO.NET etc. and is
well documented in msdn library (library.msdn.com).
 
Back
Top