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 ] ...
Simple CREATE TABLE syntax (common if not using options): syntaxsql Copy CREATE TABLE { database_name.schema_name.table_name | schema_name.table_name | table_name } ( { <column_definition> } [ ,... n ] ) [ ; ] Full syntax Disk-based CREATE TABLE syntax: syntaxsql Copy CREATE...
Transact-SQL syntax conventions Syntax options Common syntax Simple CREATE TABLE syntax (common if not using options): syntaxsql نسخ CREATE TABLE { database_name.schema_name.table_name | schema_name.table_name | table_name } ( { <column_definition> } [ ,... n ] ) [ ; ] ...
Allgemeine Syntax Einfache CREATE TABLE-Syntax (allgemein, wenn keine Optionen verwendet werden): syntaxsql Kopieren CREATE TABLE { database_name.schema_name.table_name | schema_name.table_name | table_name } ( { <column_definition> } [ ,... n ] ) [ ; ] Vollständige Syntax Datent...
syntaxsql复制 CREATE[ORALTER]FUNCTION[schema_name. ]function_name( [ { @parameter_name[AS] [type_schema_name. ]parameter_data_type[NULL] [ = default ] [READONLY] } [ , ...n ] ] )RETURNSTABLE[WITH<function_option>[ , ...n ] ] [AS]RETURN[ ( ]select_stmt[ ) ] [ ; ] ...
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> [ , ......
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 ] ...
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 ] ...
CREATE LOCAL TEMPORARY TABLE tab1(c1 int) IN IQ_SHARED_TEMP 无法将 BIT 数据类型列显式置于 dbspace 中。BIT 数据类型不支持以下内容: CREATE TABLE t1(c1_bit bit IN iq_main); ON COMMIT 仅允许临时表。缺省情况下,临时表的行将在 COMMIT 时被删除。 AT 创建映射到 location-string 子句指定的远...
Syntax create_user::= Description of the illustration create_user.eps (size_clause::=) Semantics user Specify the name of the user to be created. This name can contain only characters from your database character set and must follow the rules described in the section"Database Object Naming ...