SQLCLR Examples


Hi,


Attached is some of the examples source code for the SQLCLR Demo on the 15th - Apologies for lateness - I've been out of the picture for a while with new Baby Girl;-)


I especially like the Modulo10 comparison between SQLCLR and a UDF. On My computer the SQLCLR completes in about 500 ms and the SQL UDF in about 2.5 seconds, and thats only on 81,000 rows!! Modulo 10 is a very simple calculation, imagine this on a very complex calculation like pension annuity rates, or some sort of newton-raphson iterative equation.


There are also a good few TVF examples. Please ping me if you have a difficulty with any of them. 


 


 

SQLCLR.zip


Skip to main content