如何执行表值函数 [英] How to execute Table valued function

问题描述

我有以下返回 Table 的函数.

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.

推荐答案

A TVF(表值函数) 应该是 SELECTed FROM.试试这个:

A TVF (table-valued function) is supposed to be SELECTed FROM. Try this:

select * from FN('myFunc')

这篇关于如何执行表值函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！