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.
Soyuj Kumar Sahoo