SQL 複製 > CREATE VIEW t(c1, c2) AS VALUES (0, 1), (1, 2); SQL 複製 -- Create a temporary function with no parameter. > CREATE TEMPORARY FUNCTION hello() RETURNS STRING RETURN 'Hello World!'; > SELECT hello(); Hello World! -- Create a permanent function with...
A function can have zero or more input parameters. There must be one entry in the list for each parameter that the function expects to receive. All the parameters for a function are input parameters and are nullable. For more information, see Defining the parameters in CREATE FUNCTION. ...
Applies to:SQL ServerAzure SQL DatabaseAzure SQL Managed Instance Creates a user-defined function (UDF), which is a Transact-SQL or common language runtime (CLR) routine. A user-defined function accepts parameters, performs an action such as a complex calculation, and returns the result of ...
parameters can be specified. A function can have zero or more input parameters. There must be one entry in the list for each parameter that the function expects to receive. All the parameters for a function are input parameters and are nullable. For more information, seeDefining the parameters...
建立和使用 SQL 純量函式 SQL複製 >CREATEVIEWt(c1, c2)ASVALUES(0,1), (1,2); SQL複製 -- Create a temporary function with no parameter.>CREATETEMPORARYFUNCTIONhello()RETURNSSTRINGRETURN'Hello World!'; >SELECThello(); Hello World!-- Create a permanent function with parameters.>CREATEFUNCTION...
--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 ]...
只有CLR 过程的默认值记录在 sys.parameters.default 列中。 对于 Transact-SQL 过程参数,该列将为 NULL。 OUT | OUTPUT 指示参数是输出参数。 使用 OUTPUT 参数将值返回给过程的调用方。 除非是 CLR 过程,否则 text、ntext 和 image 参数不能用作 OUTPUT 参数。 OUTPUT 参数可以为游标占位符,CLR 过程除外。
CREATE FULLTEXT CATALOG (Transact-SQL) 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)
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Creates a user-defined function (UDF), which is a Transact-SQL or common language runtime (CLR) routine. A user-defined function accepts parameters, performs an action such as a complex calculation, and returns the result ...
If RETURNS NULL ON NULL INPUT is specified in a CLR function, it indicates that SQL Server can return NULL when any of the arguments it receives is NULL, without actually invoking the body of the function. If the method of a CLR function specified in <method_specifier> already has a cust...