[dba-SQLServer] Sql Server 2008 VTF and SQL CLR

Francisco Tapia fhtapia at gmail.com
Thu Dec 15 13:48:34 CST 2011

have any of you worked with Table Valued Functions yet?  I know how to
create a SQL value table function in pure TSQL, but getting one to work
that's built off of SQL CLR is something new entirely to me  :phew:  My
sample here is simple, but the idea is that I'm going to be calling a
webservice to collect some data.  I'd like to have at least a two column
table returned so that I can create labels or maybe a multi-column with the
appropriate column name.

here is my working code from c# and this does yield me a working returned

As always your help is appreciated!

  [Microsoft.SqlServer.Server.SqlFunction(FillRowMethodName = "getFillRow",
     TableDefinition = "Field1 nvarchar(20)")]
    public static IEnumerable fngetTEST(string strSomeInput)
        ArrayList myList = new ArrayList();
        return new ArrayList(myList);
    private static void getFillRow(object obj,
        out SqlString strField1

        strField1 = Convert.ToString(obj);

http://bit.ly/sqlthis   | Tsql and More...

More information about the dba-SQLServer mailing list