在純量函數中,function_body 是一系列的 Transact-SQL 陳述式,這些陳述式會一起評估為純量值。 在多重陳述式資料表值函式中,function_body 是 Transact-SQL 陳述式序列,這些陳述式會擴展 TABLE 傳回變數。 scalar_expression 指定純量函數傳回的純量值。 TABLE 指定資料表值函式的傳回值是資料表。只有常數和...
In-Memory OLTP-Syntax für systemeigene kompilierte, skalare benutzerdefinierte Funktionen.syntaxsql Kopieren CREATE [ OR ALTER ] FUNCTION [ schema_name. ] function_name ( [ { @parameter_name [ AS ] [ type_schema_name. ] parameter_data_type [ NULL | NOT NULL ] [ = default ] [ ...
syntaxsql Copy <order_clause> ::= { <column_name_in_clr_table_type_definition> [ ASC | DESC ] } [ , ...n ] <method_specifier> ::= assembly_name.class_name.method_name <clr_function_option> ::= { [ RETURNS NULL ON NULL INPUT | CALLED ON NULL INPUT ] | [ EXECUTE_AS_Claus...
-- Transact-SQL Scalar Function SyntaxCREATE[ORALTER]FUNCTION[schema_name. ]function_name( [ { @parameter_name[AS][type_schema_name. ]parameter_data_type[NULL] [ = default ] [READONLY] } [ ,...n ] ] )RETURNSreturn_data_type[WITH<function_option>[ ,...n ] ] [AS]BEGINfunction...
CREATE FUNCTION (Transact-SQL) CREATE INDEX (Transact-SQL) CREATE LOGIN (Transact-SQL) CREATE MASTER KEY (Transact-SQL) CREATE MESSAGE TYPE (Transact-SQL) CREATE PARTITION FUNCTION (Transact-SQL) CREATE PARTITION SCHEME (Transact-SQL) CREATE PROCEDURE (Transact-SQL) ...
syntaxsql 复制 <order_clause> ::= { <column_name_in_clr_table_type_definition> [ ASC | DESC ] } [ , ...n ] <method_specifier> ::= assembly_name.class_name.method_name <clr_function_option> ::= { [ RETURNS NULL ON NULL INPUT | CALLED ON NULL INPUT ] | [ EXECUTE_AS_...
CREATE FULLTEXT INDEX (Transact-SQL) CREATE FULLTEXT STOPLIST (Transact-SQL) CREATE FUNCTION (Transact-SQL) CREATE INDEX (Transact-SQL) CREATE LOGIN (Transact-SQL) CREATE MASTER KEY (Transact-SQL) CREATE MESSAGE TYPE (Transact-SQL) CREATE PARTITION FUNCTION (Transact-SQL) CREATE PARTITION SCHEME ...
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) ...
jdbc:jtds:sqlserver://DESKTOP:1433;domain=DEVELOPMENT;instance=MSSQLSERVER;databaseName=guest; Ensure that the connection to the database can be established using the provided details. To do that, click theTest Connectionlink at the bottom of the connection details area. ...
是用于在SQL Server数据库中创建用户定义函数的语句。用户定义函数是一种可重复使用的代码块,可以接受参数并返回一个值。它们可以用于查询、计算和转换数据。 SQL Server create函数语句的基本语法如下: 代码语言:txt 复制 CREATE FUNCTION function_name ( @parameter1 data_type, @parameter2 data_type, ... ) ...