Welcome to MSDN Blogs Sign in | Join | Help

May 2005 - Posts

Friday, May 20, 2005 6:39 PM

Yet another TVF: returning files from a directory

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
Posted by sqlclr | 5 Comments
Wednesday, May 11, 2005 5:07 PM

An Enigmatic Error while Returning UDT Results

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
Posted by sqlclr | 3 Comments
Thursday, May 05, 2005 1:26 PM

File Access and table-valued functions

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 as file-access,
Posted by sqlclr | 9 Comments
Wednesday, May 04, 2005 6:10 PM

Welcome to the SQL-CLR blog

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
Posted by sqlclr | 6 Comments
 
Page view tracker