Mega Code Archive

 

Categories / MSSQL Tutorial / Procedure Function

 

Syntax for Creating Multistatement Table-Valued Functions

CREATE FUNCTION [ owner_name. ] function_name       ( [ { @parameter_name scalar_parameter_data_type            [ = default ] } [ ,...n ] ] ) RETURNS @return_variable TABLE   ( { column_definition | table_constraint } [ ,...n ] ) [ WITH { ENCRYPTION | SCHEMABINDING } [ ,...n ] ] [ AS ] BEGIN     function_body     RETURN END