Mega Code Archive

 

Categories / MSSQL Tutorial / Procedure Function

 

Syntax for Creating Inline Table-Valued Functions

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