Error: 'Table valued function 'Foo' caused an exception during resultset retrieval. Its resultsets (if any) probably aren't determined in full: Operand type clash: NULL is incompatible with Bar'

I'm not quite sure how I can solve this error. Any suggestions?

update: Hmm, it might have to do with the fact that it has a table valued parameter.

You give very little info to work on, to be honest

Am I correct in assuming you have no support yet for table valued parameters? We've had this discussion on twitter before. You were thinking of adding support after finishing the NET Core 3.x work.

there are no support for table valued parameters. we did look at supporting it but it required an existing table definition which was cumbersome to come by, so we postponed it (as it was cumbersome to define the parameter)

Hi,

I have encountered this error when adding table value function in the designer.

Error: 'The table valued function '_DocumentStore_Template.dbo.fn_VendorFile_ListFolder' has been removed because it has no valid resultset.'

Can someone please help?

Thanks & Regards,

Arn

Never mind!

casting HierarchyID SQL data type to nvarchar(4000) resolve issue.

arn wrote:

Hi,

I have encountered this error when adding table value function in the designer.

Error: 'The table valued function '_DocumentStore_Template.dbo.fn_VendorFile_ListFolder' has been removed because it has no valid resultset.'

Can someone please help?

Thanks & Regards,

Arn