对于CREATE FUNCTION 语句中指定的任何表或视图,不考虑 PUBLIC 以外的组特权。 调用函数时,将应用昵称所引用的表或视图的数据源的授权需求。 该连接的授权标识可以映射到不同的远程授权标识。 此语句的授权标识所拥有的特权还必须包括调用函数体中指定的 SQL 语句所需的所有特权。 要替换现有函数,语句的授权标识必须...
syntaxsql Kopieren CREATE [ OR ALTER ] FUNCTION [ schema_name. ] function_name ( [ { @parameter_name [ AS ] [ type_schema_name. ] parameter_data_type [ NULL ] [ = default ] [ READONLY ] } [ , ...n ] ] ) RETURNS TABLE [ WITH <function_option> [ , ...n ] ] [ AS ...
--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 ] ...
SHOWCREATEFUNCTIONSHOWCREATEPROCEDURESHOWCREATETABLESHOWCREATEUSERSPATIAL mysql> 2>.查看CREATE DATABASE命令的帮助信息 mysql>?CREATEDATABASEName:'CREATE DATABASE'Description: Syntax:CREATE{DATABASE|SCHEMA}[IF NOT EXISTS]db_name[create_specification]... create_specification:[DEFAULT]CHARACTERSET[=]charset_na...
Syntax CREATE OR REPLACE FUNCTIONname(,parameter-nameINOUTIN OUTdata-typedefault-clause)RETURNreturn-type PIPELINED ISASdeclarationBEGIN statement EXCEPTIONWHENexceptionORexceptionTHENstatementENDname Description The CREATE FUNCTION statement specifies the name of the function, the optional parameters, the return...
14.1.16 CREATE PROCEDURE and CREATE FUNCTION Syntax 14.1.17 CREATE SERVER Syntax 14.1.18 CREATE TABLE Syntax 14.1.18.1 CREATE TABLE ... LIKE Syntax 14.1.19 CREATE TABLESPACE Syntax 14.2.1 CALL Syntax 14.2.2 DELETE Syntax 14.2.3 DO Syntax ...
-- 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 parameters. > CREATE FUNCTION area(x DOUBLE, y DOUBLE) RETURNS DOUBLE RETURN ...
syntaxsql 复制 CREATE [ OR ALTER ] FUNCTION [ schema_name. ] function_name ( { @parameter_name [ AS ] [ type_schema_name. ] parameter_data_type [ NULL ] [ = default ] } [ , ...n ] ) RETURNS TABLE <clr_table_type_definition> [ WITH <clr_function_option> [ , ...n ] ...
Syntax create sql function <function_name>(@<parameter_in1> <datatype>[, @<parameter_in2> <datatype>...]) [returns @<parameter_out> <datatype>] as [begin] <function_expression> [end]; Parameters function_name: required. This parameter specifies the name of the SQL UDF that you creat...
Basic Syntax - tvf_SearchLogU-SQL Copy CREATE DATABASE IF NOT EXISTS TestReferenceDB; USE DATABASE TestReferenceDB; DROP FUNCTION IF EXISTS tvf_SearchLog; CREATE FUNCTION tvf_SearchLog() RETURNS @searchlog TABLE(UserId int, Start DateTime, Region string, Query string, Duration int?, Url...