SqlPipe output from CLR sproc  
Author Message
acchong





PostPosted: Fri Apr 21 01:57:03 CDT 2006 Top

SQL Server Developer >> SqlPipe output from CLR sproc

How would I go about capturing the output of a stored procedure that is
being returned through a SqlPipe? I have to write a CLR sproc in c#, and I
need get a string value out of it in the middle of a t-sql script. The only
way that I can figure out how to get the string back out is using the
SqlPipe. Everything work hunky-dory, and the correct output is written to
the screen when im in Management Studio, but I really need to shove this
string into a variable in the t-sql script and I cant for the life of me
figure out how!

any help, insight, or direction towards information on this subject would
be greatly appreciated.

TIA
Charles

SQL Server151  
 
 
Adam





PostPosted: Fri Apr 21 01:57:03 CDT 2006 Top

SQL Server Developer >> SqlPipe output from CLR sproc Can you send the string back as an output parameter? There is no way to
capture a message (which is what SqlPipe.Send(string) sends) in T-SQL.


--
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--




> How would I go about capturing the output of a stored procedure that is
> being returned through a SqlPipe? I have to write a CLR sproc in c#, and I
> need get a string value out of it in the middle of a t-sql script. The
> only
> way that I can figure out how to get the string back out is using the
> SqlPipe. Everything work hunky-dory, and the correct output is written to
> the screen when im in Management Studio, but I really need to shove this
> string into a variable in the t-sql script and I cant for the life of me
> figure out how!
>
> any help, insight, or direction towards information on this subject would
> be greatly appreciated.
>
> TIA
> Charles
>


 
 
charles





PostPosted: Fri Apr 21 15:08:34 CDT 2006 Top

SQL Server Developer >> SqlPipe output from CLR sproc Got it !! thanks :) i just got hung up trying to make the sqlPipe work,
output params work perfect.

-Charles




> Can you send the string back as an output parameter? There is no way to
> capture a message (which is what SqlPipe.Send(string) sends) in T-SQL.
>