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: ...
Using SQL Server 2005 and .NET 3.5. I have a SQL stored procedure [collection and validation of parameters] which references some CLR table valued functions [some complex mathematics]. The table valued functions, in turn, call a SQL stored procedure doing
We have the OurStoredProcedures.dll with stored procedures in C#. We programatically deploy these stored procedures to the local SQL Server, using SQL command with the "CREATE PROCEDURE ..."statement. Also we are creating an assembly on the server.