SQLEXEC( ) Function AI Skills Fest April 8 – May 28, 2025 Register now Dismiss alert Learn Sign in We're no longer updating this content regularly. Check theMicrosoft Product Lifecyclefor information about how this product, service, technology, or API is supported....
Indicates that the SQL command (INSERT, UPDATE, or DELETE) did not return a result set. Count Number of affected or fetched records. Integer Indicates the number of affected records as returned by the ODBC SQLRowCount function. Returns -1 if the number of records is unavailable. ...
(Function returns SQL_SUCCESS_WITH_INFO.) 01003NULL value eliminated in set functionThe argumentStatementTextcontained a set function (such asAVG,MAX,MIN, and so on), but not theCOUNTset function, and NULL argument values were eliminated before the function was applied. (Function returns SQL_SU...
SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance Returns aggregate performance statistics for cached functions. The view returns one row for each cached function plan, and the lifetime of the row is as long as the function remains cache...
EXEC sp_executesql @Sql, @ParmDefinition, @IdOUT = @Id OUTPUT RETURN @Id END Usage: Copy SELECT dbo.Getid('Contact') Result: Copy Msg 557, Level 16, State 2, Line 1 Only functions and some extended stored procedures can be executed from within a function. ...
如果語句中有任何參數存在,SQLExecDirect 會使用參數標記變數的目前值來執行可預先剖析的語句。 SQLExecDirect 是提交 SQL 語句以進行一次性執行最快的方式。 語法 C++ 複製 SQLRETURN SQLExecDirect( SQLHSTMT StatementHandle, SQLCHAR * StatementText, SQLINTEGER TextLength); 引數 StatementHandle [輸入]語句...
Open 有返回值,ExecSQL 无返回值 //2021.02.03 补充 ExecSQL 语法原型: 1 functionExecSQL:Integer; 描述: 调用ExecSQL以执行当前分配给SQL属性的SQL语句。使用ExecSQL执行不将游标返回到数据的查询(例如INSERT、UPDATE、DELETE和CREATE TABLE)。 ExecSQL返回一个整数值,反映受已执行SQL语句影响的行数。
CREATEPROCEDUREexec_return_table_functionASBEGIN-- 执行函数END 1. 2. 3. 4. 5. 此代码用于创建一个名为exec_return_table_function的存储过程。 2. 执行函数 AI检测代码解析 DECLARE@result_tableTABLE(-- 定义结果集的字段idINT,nameVARCHAR(50))INSERTINTO@result_tableEXECyour_table_function_name ...
Azure 门户下载 SQL Server 此主题的部分內容可能由机器或 AI 翻译。 消除警报 版本 SQL Server 2022 搜索 SQLBulkOperations 函数 SQLCancel 函数 SQLCancelHandle 函数 SQLCloseCursor 函数 SQLColAttribute 函数 SQLColAttributes 函数 SQLColumnPrivileges 函数 ...
Database connection, specified as an ODBCconnectionobject or JDBCconnectionobject created using thedatabasefunction. sqlquery—SQL query string scalar|character vector SQL query, specified as a string scalar or character vector. You can specify the SQL query as a nested query or as a stored proced...