|
|
SqlPipe output from CLR sproc |
|
Author |
Message |
acchong
|
Posted: 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
|
Posted: 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
|
Posted: 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.
>
|
|
|
|
|
|
|