CREATEFUNCTIONfunction_name(@parameter_nameparameter_data_type)--CREATE FUNCTION 函数名称(@参数名 参数的数据类型)RETURNS@Table_Variable_Nametable(Column_1 culumn_type,Column_2 culumn_type)--RETURNS @表变量 table 表的定义(即列的定义和约束)[WITH ENCRYPTION]--如果指定了 encryption 则函数被加密[AS...
function_body:指定一系列的Transact-SQL 语句,它们决定了函数的返回值。 ENCRYPTION:加密选项。让SQL Server 对系统表中有关CREATE FUNCTION 的声明加密,以防止用户自定义函数作为SQL Server 复制的一部分被发布(Publish) 。 SCHEMABINDING:计划绑定选项将用户自定义函数绑定到它所引用的数据库对象如果指定 了此选项,则...
The CREATE FUNCTION (SQL table) statement creates an SQL table function at the current server. The function returns a set of rows. Invocation for CREATE FUNCTION (SQL table) This statement can only be dynamically prepared only if dynamic rules run behavior is in effect. For more information, ...
] function_name ( [ { @parameter_name [ AS ] [ type_schema_name. ] parameter_data_type [ NULL ] [ = default ] [ READONLY ] } [ , ...n ] ] ) RETURNS @return_variable TABLE <table_type_definition> [ WITH <function_option> [ , ...n ] ] [ AS ] BEGIN function_body ...
(DM) The SQL_ATTR_METADATA_ID statement attribute was set to SQL_TRUE, and theSchemaNameorTableNameargument was a null pointer. HY010Function sequence error(DM) An asynchronously executing function was called for the connection handle that is associated with theStatementHandle. This asynchronous fu...
EXEC SQL INSERT INTO <table_name> ( col_list ) VALUES ( expr | :host_variable ) INSERT 语句的语法遵循 OceanBase Oracle 模式中 INSERT 语句的语法规则。 示例语句如下所示: int c1val = 0; char * c2val = "demo"; EXEC SQL CREATE TABLE t1 (c1 int,c2 varchar2(100)); EXEC SQL INSERT...
如果SQL_ATTR_METADATA_ID語句屬性設定為 SQL_TRUE,則 TableName 會被視為識別碼, 而且其大小寫並不重要。 如果它是SQL_FALSE, TableName 是一般引數;它會以常值方式處理,而且其大小寫很重要。NameLength3 [輸入]*TableName 的字元長度 。唯一 [輸入]索引的類型:SQL_INDEX_UNIQUE或SQL_INDEX_ALL。
SQLRETURN SQLTablePrivileges( SQLHSTMT StatementHandle, SQLCHAR * CatalogName, SQLSMALLINT NameLength1, SQLCHAR * SchemaName, SQLSMALLINT NameLength2, SQLCHAR * TableName, SQLSMALLINT NameLength3); 参数 StatementHandle [输入]语句句柄。 CatalogName [输入]表目录。 如果驱动程序支持某些表...
, meaning the function is still executing. Example The following example assumes an ODBC data source called MyFoxSQLNT is available, and the user ID for the data source is "sa." SQLCONNECT( ) is issued, and its return value is stored to a variable named gnConnHandle. If you cannot ...
SQLSetCursorName Function SQLSetDescField Function SQLSetDescRec Function SQLSetEnvAttr Function SQLSetParam Function SQLSetPos Function SQLSetScrollOptions Function SQLSetStmtAttr Function SQLSetStmtOption Function SQLSpecialColumns Function SQLStatistics Function SQLTablePrivileges Function SQLTables Function SQLTr...