The above discussion describes an easier way of creating CLR integrated database objects than the previous one, discussed in my first article. It uses the Visual Studio 2005 which is very familiar to all of us. This is very helpful when we develop an application in Remote machine. Again, CLR integrated user defined functions (UDFs) have some added advantage over T-SQL UDFs. In the case of Table-Valued Functions (TVFs), Transact-SQL materializes the results of calling the function into an intermediate table, while CLR TVFs represent a streaming alternative.

By

Soyuj Kumar Sahoo

Mindfire Solutions