----------------------------------------------:定義表值類型：（1.一定返回的是IEnumerable2.一定帶參數(shù)3.一定有FillRowMethodName和TableDefinition參數(shù)）
public partial class UserDefinedFunctions
{
[Microsoft.SqlServer.Server.SqlFunction(DataAccess=DataAccessKind.Read, TableDefinition="Name nvarchar(100),ClassName nvarchar(100)",FillRowMethodName="FillTable",IsDeterministic=true)]
public static IEnumerable TableTest(SqlString str)
{

ArrayList list =new ArrayList{

new Student{ Name="郭澤峰",ClassName="沈陽理工大學(xué)103361"},
new Student{Name="郭澤峰1",ClassName="沈陽理工大學(xué)103361"},
new Student{Name="郭澤峰2",ClassName="沈陽理工大學(xué)103361"},
};
return list;
}
public static void FillTable(object obj, out SqlString name, out SqlString className)
{
Student s = obj as Student;
name = "";
className = "";
if (s != null)
{
name = s.Name;
className = s.ClassName;
}
}
};

sqlclr創(chuàng)建表值函數(shù)案例