How to execute Table valued function

Question

I have following function which returns Table    create Function FN  Str varchar 30     returns    Names table name varchar 25     as    begin         while  charindex       str   gt  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

User · Answer

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)

User · Answer

A TVF  table-valued function  is supposed to be SELECTed FROM  Try this   select   from FN  myFunc

[sql] How to execute Table valued function

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2008

Examples related to tsql