Tutorial Needed...

[Anibal]

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.

 

[Ludwig]

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/d...ml/cpconinputoutputparametersreturnvalues.asp
http://msdn.microsoft.com/library/d...ml/cpconinputoutputparametersreturnvalues.asp

 

[Anibal]

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.

 

[Guest]

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

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.

 

[Martin Milan]

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

 

[Anibal]

Ok, i got it.
Thanks a lot.
I will study deeper and then ask here if i have any quastions.
Bye.

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.