syntaxsql 复制 CREATE [ OR ALTER ] FUNCTION [ schema_name. ] function_name ( { @parameter_name [ AS ] [ type_schema_name. ] parameter_data_type [ NULL ] [ = default ] } [ , ...n ] ) RETURNS { return_data_type } [ WITH <clr_function_option> [ , ...n ] ] [ AS ]...
syntaxsql 複製 CREATE [ OR ALTER ] FUNCTION [ schema_name. ] function_name ( [ { @parameter_name [ AS ] [ type_schema_name. ] parameter_data_type [ NULL ] [ = default ] [ READONLY ] } [ , ...n ] ] ) RETURNS return_data_type [ WITH <function_option> [...
--Transact-SQL Scalar Function Syntax 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 ] ...
如需詳細資訊,請參閱 CREATE FUNCTION (Transact-SQL) 中的SCHEMABINDING 一節。 LANGUAGE = [N] 'language' 適用於:SQL Server 2014 (12.x) 和更新版本,以及 Azure SQL Database。 相當於 SET LANGUAGE (Transact-SQL) 工作階段選項。 需要 LANGUAGE = [N] 'language'。 TRANSACTION ISOLATION LEVEL 適用於...
CREATE ENDPOINT (Transact-SQL) CREATE EVENT NOTIFICATION (Transact-SQL) CREATE FULLTEXT CATALOG (Transact-SQL) CREATE FULLTEXT INDEX (Transact-SQL) CREATE FUNCTION (Transact-SQL) CREATE INDEX (Transact-SQL) CREATE LOGIN (Transact-SQL) CREATE MASTER KEY (Transact-SQL) ...
The CREATE FUNCTION (SQL table) statement creates an SQL table function at the current server. The function returns a set of rows.
In multistatement table-valued functions,@return\_variableis a TABLE variable, used to store and accumulate the rows that should be returned as the value of the function.@return\_variablecan be specified only for Transact-SQL functions and not for CLR functions. ...
CREATE ENDPOINT (Transact-SQL) CREATE EVENT NOTIFICATION (Transact-SQL) CREATE FULLTEXT CATALOG (Transact-SQL) CREATE FULLTEXT INDEX (Transact-SQL) CREATE FUNCTION (Transact-SQL) CREATE INDEX (Transact-SQL) CREATE LOGIN (Transact-SQL) CREATE MASTER KEY (Transact-SQL) ...
Is the single SELECT statement that defines the return value of an inline table-valued function. EXTERNAL NAME <method_specifier>,assembly_name.class_name.method_name Specifies the method of an assembly to bind with the function.assembly_namemust match an existing assembly in SQL Server in the ...
function-designator FUNCTIONfunction-name(,data-type)SPECIFIC FUNCTIONspecific-name Notes: 1The FOR BIT DATA clause can be specified in any order with the other column constraints that follow. The FOR BIT DATA clause cannot be specified with string units CODEUNITS32 (SQLSTATE 42613). ...