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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Call stored procedure with paremeter output in c# 7
Pass SecureString value to SQLS Stored Procedure 1
execute "big" stored procedure - insert data in SQL Database 2
Command Parameters 2
Intercepting invalid parameters to a stored procedure 10
What are the steps to fix damaged MDF files in SQL Server? 0
Error in eConnect while creating PO in Great plains 0

Back
Top