Creating a C# CLR Stored Procedure

[RDWilsonII]

I want to create a C# CLR Stored Proc because I want to add a level of security to the code for the Stored Proc. I need to this CLR-SP to access some tables in a SQL Server database in order to load some variables, some vectors, and some arrays and then perform some calculations which will result in a vector of results. My problem is that, while I've got some knowledge of C# and a lot of knowledge about SQL Server, I've only created a couple of CLR Functions (and that was before I retired).

So, what I really need is what we used to call a "skeleton program" that would define a stored proc in C# and that would include at least one example of executing a query and then filling a vector with the results.


Ralph D. Wilson II, MCTS SQL Server Sr. Data Warehouse Developer

Continue reading...