In my previous BLOG entry dated May 5th, I promised another sample that retrieves multiple files from a directory based on a specified name pattern. Here it is, this time in VB.NET. This is a more traditional Table-Valued-Function in that it actually...

Let's say we have a very simple (and silly) CLR UDT defined and loaded into SQL Server named CLRInt, which exists solely to wrap a .NET integer and provide a ToString() method. We can now try to perform a very basic manipulation of this type: declare...

In this article, we will discuss a sample CLR function that illustrates accessing an external resource such as a file from inside a SQL Server stored procedure or function, . The sample highlights a number of different features and concepts, such...

We hope to use this blog to communicate with the SQL Server user community on the CLR Integration features in SQL Server 2005 (sometimes known affectionately as SQL-CLR). This feature enables writing stored procedures, triggers, functions, user-defined...