Stored Proc return value (Weird Question)

[Guest]

Is it in any way possible to have a sProc called and executed within
SQLServer return its return value to an open .Net Vb application?

As a programmer I beleive this can be done and if I wreck my head enough I
will find a way. I have toyed with the ideas of xml, SQLServer events but
have found nothing so far.

As this is the final stage of my project I really would appreciate any input
given.

Thanks
marc.

 

[Larry Lard]

Is it in any way possible to have a sProc called and executed within
SQLServer return its return value to an open .Net Vb application?

As a programmer I beleive this can be done and if I wreck my head enough I
will find a way. I have toyed with the ideas of xml, SQLServer events but
have found nothing so far.

As this is the final stage of my project I really would appreciate any input
given.

Short answer: in the SqlCommand that calls the SP in question, have a
SqlParameter with its Direction set to ParameterDirection.ReturnValue -
when you execute the SqlCommand (even if you just .ExecuteNonQuery),
the Parameter's Value will be populated with the SP's return value.

If none of that made sense, ask again

 

[Guest]

if you want to do the things much easier, download the application data
blocks....

 

[Guest]

Thanks Larry / Rothariger

Larry: It's a very weird one, I am not calling the sProc from the app, but
from SQLServer
However I somehow want to record the @result somewhere within the application.
I honestly don't know if it can be done.

Rothariger: What are application blocks?

 

[Guest]

here http://support.microsoft.com/default.aspx?scid=kb;en-us;829028 once do
you use it, you cant leave it...

 

[Zoury]

Hi !

However I somehow want to record the @result somewhere within the application.
I honestly don't know if it can be done.

How about writing the results in a table and read them back from .NET
whenever needed ?