René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Syntax for table function in T-SQL

Inline table function

CREATE FUNCTION [ owner_name. ] function_name 
 ( [ { @parameter_name [AS] scalar_parameter_data_type [ = default ] } [ ,...n ] ] ) 
 
 RETURNS TABLE 
 
 [ WITH <function_option > [ [,] ...n ] ] 
 
 [ AS ] 
 
 RETURN [ ( ] select-stmt [ ) ]

Multistatement table function

REATE FUNCTION [ owner_name. ] function_name 
 ( [ { @parameter_name [AS] scalar_parameter_data_type [ = default ] } [ ,...n ] ] ) 
 
 RETURNS @return_variable TABLE < table_type_definition > 
 
 [ WITH < function_option > [ [,] ...n ] ] 
 
 [ AS ] 
 
 BEGIN 
 function_body 
 RETURN
 END