Creating CLR table function with T-SQL producing error msg 6208.

• fxferguson

  SSC-Addicted

  Points: 485

  More actions

  March 7, 2016 at 2:36 pm

  #309189

  I created an assembly using T-SQL. I then tried to create the function using T-SQL but I get the error:

  "CREATE FUNCTION failed because the parameter count for the FillRow method should be one more than the SQL declaration for the table valued CLR function."

  I couldn't find anything helpful on the web.

  C# code and T-SQL statement attached.

  Any help would be greatly appreciated.

  Thanks!

• Hugo Kornelis

  SSC Guru

  Points: 64790

  More actions

  March 9, 2016 at 12:38 pm

  #1864090

  The T-SQL declaration of the function includes a column FilePath that is missing in the code of the assembly.

  ---

  Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
  Visit my SQL Server blog: https://sqlserverfast.com/blog/
  SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/
  

• fxferguson

  SSC-Addicted

  Points: 485

  More actions

  March 9, 2016 at 12:48 pm

  #1864092

  Thanks Hugo,

  I just caught that as well. I've updated the code .NET code and it's working now.

  Have a great da.