Page History

Call parameterized functions within the FROM clause of a SELECT statement.
The function returns a table in a specified format and the results work like a table with the specified alias.
Table value functions can take 0-n nparameters.
Example - Shows how to declare a table value function that takes one parameter and outputs a table with two columns. @outputTable works as virtual table where the output goes.
create function tvf_example ( @param1 integer ) 
returns @outputTable table ( col1 int ,col2 int )
as BEGIN
  insert into \[@outputTable\] select @param1,2
end
select * from tvf_example(10248) as xxx