 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Programming / CLR / November 2008How to pass SQL table type parameter INTO C# CLR SQL stored procedure
Hi. Thank you for your expertise. I am trying to find out how ot pass data in SQL Server 2008 table type into C# CLR stored procedure from SQL stored procedure. I've found lots of references how to pass it out of CLR procedure to SQL procedure but none the other way. My plan is: from SQL stored proc, fill table type variable with data, pass it into CLR proc, do some calculations and pass this calculated result out. I understand that I either need to pass it out as a resultset, or call another SQL proc and pass into it a table type variable content. Please lead me to any example. Any tips are welcome. thank you. vladimir Hi Vladimir, TVPs are not supported as input to SQLCLR procs. Cheers, Bob Beauchemin SQLskills Hi. Thank you for your expertise. I am trying to find out how ot pass data in SQL Server 2008 table type into C# CLR stored procedure from SQL stored procedure. I've found lots of references how to pass it out of CLR procedure to SQL procedure but none the other way. My plan is: from SQL stored proc, fill table type variable with data, pass it into CLR proc, do some calculations and pass this calculated result out. I understand that I either need to pass it out as a resultset, or call another SQL proc and pass into it a table type variable content. Please lead me to any example. Any tips are welcome. thank you. vladimir Thank you, Bob! Hi Vladimir, TVPs are not supported as input to SQLCLR procs. Cheers, Bob Beauchemin SQLskills "Farmer" <someone@somewhere.com> wrote in message news:9DF9C255-AFB8-45D9-94F7-D7A67BB0FA76@microsoft.com... Hi. Thank you for your expertise. I am trying to find out how ot pass data in SQL Server 2008 table type into C# CLR stored procedure from SQL stored procedure. I've found lots of references how to pass it out of CLR procedure to SQL procedure but none the other way. My plan is: from SQL stored proc, fill table type variable with data, pass it into CLR proc, do some calculations and pass this calculated result out. I understand that I either need to pass it out as a resultset, or call another SQL proc and pass into it a table type variable content. Please lead me to any example. Any tips are welcome. thank you. vladimir |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.