sql create Function.docVIP

CREATE FUNCTION (Transact-SQL) 创建用户定义函数。这是一个已保存 Transact-SQL 或公共语言运行时 (CLR) 例程，该例程可返回一个值。用户定义函数为标量值函数或表值函数。如果 RETURNS 子句指定了一种标量数据类型，则函数为标量值函数。可以使用多条 Transact-SQL 语句定义标量值函数。如果 RETURNS 子句指定 TABLE，则函数为表值函数。根据函数主体的定义方式，表值函数可分为内联函数或多语句函数。有关详细信息，请参阅表值用户定义函数。 用户定义函数可使用 ALTER FUNCTION 修改，使用 DROP FUNCTION 删除。 Transact-SQL 语法约定 语法 复制 Scalar Functions CREATE FUNCTION [ schema_name. ] function_name ( [ { @parameter_name [ AS ][ type_schema_name. ] parameter_data_type [ = default ] [ READONLY ] } [ ,...n ] ] ) RETURNS return_data_type [ WITH function_option [ ,...n ] ] [ AS ] BEGIN function_body RETURN scalar_expression END [ ; ] Inline Table-Valued Functions CREATE FUNCTION [ schema_name. ] function_name ( [ { @parameter_name [ AS ] [ type_schema_name. ] parameter_data_type [ = default ] [ READONLY ] } [ ,...n ] ] ) RETURNS TABLE [ WITH function_option [ ,...n ] ] [ AS ] RETURN [ ( ] select_stmt [ ) ] [ ; ] Multistatement Table-valued Functions CREATE FUNCTION [ schema_name. ] function_name ( [ { @parameter_name [ AS ] [ type_schema_name. ] parameter_data_type [ = default ] [READONLY] } [ ,...n ] ] ) RETURNS @return_variable TABLE table_type_definition [ WITH function_option [ ,...n ] ] [ AS ] BEGIN function_body RETURN END [ ; ] CLR Scalar Functions CREATE FUNCTION [ schema_name. ] function_name ( { @parameter_name [AS] [ type_schema_name. ] parameter_data_type [ = default ] } [ ,...n ] ) RETURNS { return_data_type } [ WITH clr_function_option [ ,...n ] ] [ AS ] EXTERNAL NAME method_specifier [ ; ] CLR Table-Valued Functions CREATE FUNCTION [ schema_name. ] function_name ( { @parameter_name [AS] [ type_schema_name. ] parameter_data_type [ = default ] } [ ,...n ] ) RETURNS TABLE clr_table_type_definition [ WITH clr_function_option [ ,...n ] ] [ ORDER ( order_clause ) ] [ AS ] EXTERNAL NAME m