Hi,
I need a tutorial (URL) that explains the use of SqlCommand to execute
Stored Procedures that return values in SQL Server 2000; also the meaning
and use of the diferent types of parameter (Output, Input, Return Value).
Thank you very mutch. 5 1189
Thank you,
Very quick answer.
But i steal don't get the differences between Output and Input parameters;
especificaly, i don't understand
What is the proupose of Output parameters?
If you or anyone else can give me a quick explanation i will be
appreciattied.
Thanks.
"Ludwig" <no**@none.com> escribió en el mensaje
news:rs********************************@4ax.com... On Mon, 29 May 2006 11:32:06 -0300, "Anibal" <no****@sinbasura.com> wrote:
Hi, I need a tutorial (URL) that explains the use of SqlCommand to execute Stored Procedures that return values in SQL Server 2000; also the meaning and use of the diferent types of parameter (Output, Input, Return Value).
Thank you very mutch.
http://msdn.microsoft.com/library/de...turnvalues.asp http://msdn.microsoft.com/library/de...turnvalues.asp -- Ludwig Stuyck http://www.coders-lab.be
Anibal,
An output parameter is populated with a value by the stored procedure and is
available, with that value, to the caller after the Command is run and the
connection closed.
You should search for a good .NET / SQL Tutorial or book and study these
basics, or you are likely to be spending a lot of time posting to newsgroups
and waiting around for answers.
Good luck!
Peter
--
Co-founder, Eggheadcafe.com developer portal: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
"Anibal" wrote: Thank you, Very quick answer. But i steal don't get the differences between Output and Input parameters; especificaly, i don't understand What is the proupose of Output parameters?
If you or anyone else can give me a quick explanation i will be appreciattied. Thanks. "Ludwig" <no**@none.com> escribió en el mensaje news:rs********************************@4ax.com... On Mon, 29 May 2006 11:32:06 -0300, "Anibal" <no****@sinbasura.com> wrote:
Hi, I need a tutorial (URL) that explains the use of SqlCommand to execute Stored Procedures that return values in SQL Server 2000; also the meaning and use of the diferent types of parameter (Output, Input, Return Value).
Thank you very mutch.
http://msdn.microsoft.com/library/de...turnvalues.asp http://msdn.microsoft.com/library/de...turnvalues.asp -- Ludwig Stuyck http://www.coders-lab.be
"Anibal" <no****@sinbasura.com> wrote in
news:uG**************@TK2MSFTNGP05.phx.gbl: Thank you, Very quick answer. But i steal don't get the differences between Output and Input parameters; especificaly, i don't understand What is the proupose of Output parameters?
Output parameters allow the stored procedures to return information back
to the client. It's just a mechanism so that the procedure can return
one or more return values, as opposed to a user defined function, which
can only return one.
Not all stored procedures return a collection of records you know...
Martin
Ok, i got it.
Thanks a lot.
I will study deeper and then ask here if i have any quastions.
Bye.
"Anibal" <no****@sinbasura.com> escribió en el mensaje
news:uG**************@TK2MSFTNGP05.phx.gbl... Thank you, Very quick answer. But i steal don't get the differences between Output and Input parameters; especificaly, i don't understand What is the proupose of Output parameters?
If you or anyone else can give me a quick explanation i will be appreciattied. Thanks. "Ludwig" <no**@none.com> escribió en el mensaje news:rs********************************@4ax.com... On Mon, 29 May 2006 11:32:06 -0300, "Anibal" <no****@sinbasura.com> wrote:
Hi, I need a tutorial (URL) that explains the use of SqlCommand to execute Stored Procedures that return values in SQL Server 2000; also the meaning and use of the diferent types of parameter (Output, Input, Return Value).
Thank you very mutch.
http://msdn.microsoft.com/library/de...turnvalues.asp http://msdn.microsoft.com/library/de...turnvalues.asp -- Ludwig Stuyck http://www.coders-lab.be
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: mir nazim |
last post by:
hi
i m in need of a PyXPCOM tutorial. it should explain using python
(instead of JavaScript) for creating apps. if any body can point me to
some web resources or a printed book .
thankz
|
by: Jive Dadson |
last post by:
I'm trying (without conspicuous success) to start learning
wxPython. Sooo... I opened the doc page wxPythonManual.html#wxpython-overview.
The very first example does not work. Try it. I find...
|
by: Alf P. Steinbach |
last post by:
Just because there seems to be a lack of post-standard _correct_
tutorials: <url: http://home.no.net/dubjai/win32cpptut/>.
Disclaimer: written this evening so perhaps there are "bugs" in the...
|
by: enea |
last post by:
http://www.ends.cx.la/
|
by: Alf P. Steinbach |
last post by:
The seventh part of my attempted Correct C++ tutorial is now available,
although for now only in Word format (use free Open Office if no Word), and
also, it's not yet been reviewed at all -- ...
|
by: Xah Lee |
last post by:
i've started to read python tutorial recently.
http://python.org/doc/2.3.4/tut/tut.html
Here are some quick critique:
quick example:
If the input string is too long, they don't truncate it,...
|
by: Bob hotmail.com> |
last post by:
Everyone
I have been spending weeks looking on the web for a good tutorial on how to use regular expressions and other methods to satisfy my craving for learning how to do FAST c-style syntax...
|
by: Andrew Baker |
last post by:
Coming from VB, I find the changes needed to manipulate a datagrid are much
more taxing than previously.
Is there a good tutorial for things like:
Setting the column widths
making the grid...
|
by: Magnus Lycka |
last post by:
While the official Python Tutorial has served its
purpose well, keeping it up to date is hardly anyones
top priority, and there are others who passionately
create really good Python tutorials on...
|
by: scubak1w1 |
last post by:
Hello,
I have a form where users select various parameters from drop down boxes to query and then get to to see the results for the their selection.
The pulldowns are populated via some...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |