Table valued functions - can the table definition differ based on parameters?

Question

Post reply

Table valued functions - can the table definition differ based on parameters?

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

MohammedU SSCoach Points: 19644 More actions · Answer 1

I don't think it is possible.

MohammedU
Microsoft SQL Server MVP

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

Not 100% sure. But I'm 99.999999999999% sure it can't be done at the moment or ever for that matter.

What problem are you trying to solve with this solution?

Paul van der Eerden SSC Enthusiast Points: 148 More actions · Answer 3

Thanks for the replies.

I just want to know if I can assume the fields are going to be the same for table-valued functions because in one part of my UI all I need are the field names (not their values) and I want to delay binding the function to a parameter until later in the application.

Paul

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

SET FMTONLY ON

GO

SELECT * FROM dbo.FnName ('Dummy value')

GO

SET FMTONLY OFF

This will return the column names only without executing the Query.