SQL Server administration and T-SQL development, Web Programming with ASP.NET and Javascript, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software

Kodyaz Development Resources

Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Vista, etc.

Home

Articles

IT Jobs

Kodyaz Development Resources » MS SQL Server » Microsoft SQL Server 2008 » Re: CLR Function - The SqlFunctionAttribute of the Init method for a CLR table-valued function must set the FillRowMethodName property.

Re: CLR Function - The SqlFunctionAttribute of the Init method for a CLR table-valued function must set the FillRowMethodName property.

09-01-2010, 9:14 AM

eralper
Joined on 01-09-2005
Posts 1,236

Re: CLR Function - The SqlFunctionAttribute of the Init method for a CLR table-valued function must set the FillRowMethodName property.

Reply Quote

Hello,

My SQL CLR split function code (VB.NET) was as follows :

<SqlFunction()>

When I set the FillRowMethodName property of SqlFunctionAttribute attribute as follows, the exception is solved
<SqlFunction(FillRowMethodName:="FillRow", TableDefinition:="Value nvarchar(4000)")>

Note that I have also defined the table structure, I mean the table columns in order using the TableDefinition property.

Eralper
Kodyaz.com

Report abuse

View Complete Thread