How to execute Table valued function
155,030
Solution 1
A TVF (table-valued function) is supposed to be SELECTed FROM. Try this:
select * from FN('myFunc')
Solution 2
You can execute it just as you select a table using SELECT
clause. In addition you can provide parameters within parentheses.
Try with below syntax:
SELECT * FROM yourFunctionName(parameter1, parameter2)
Author by
Shine
Updated on July 05, 2022Comments
-
Shine about 2 years
I have following function which returns Table .
create Function FN(@Str varchar(30)) returns @Names table(name varchar(25)) as begin while (charindex(',', @str) > 0) begin insert into @Names values(substring(@str, 1, charindex(',', @str) - 1)) set @str = substring(@str, charindex(',', @str) + 1, 100) end insert into @Names values(@str) return end
Could any one please explain me how to run this function.
-
apc over 7 yearsNote that depending upon the server/setup you may need to identify the schema e.g. select * from dbo.FN('myFunc')