DECLARE CURSOR (Transact-SQL) - SQL Serverdocs.microsoft.com/zh-cn/sql/t-sql/language-elements/declare-cursor-transact-sql?view=sql-server-ver15 语法 --ISO Syntax ISO标准语法 DECLARE cursor_name[ INSENSITIVE ] [ SCROLL ] CURSOR FOR select_statement [ FOR { READ ONLY | UPDATE [ ...
...n]] } ][;]Transact-SQL Extended SyntaxDECLAREcursor_nameCURSOR[LOCAL | GLOBAL][FORWARD_ONLY | SCROLL][STATIC | KEYSET | DYNAMIC | FAST_FORWARD][READ_ONLY | SCROLL_LOCKS | OPTIMISTIC][TYPE_WARNING]FORselect_statement[FOR UPDATE [ OF column_name [ ...
适用范围:SQL Server 请求定位更新。 此过程对游标的提取缓冲区内的一行或多行执行操作。 sp_cursor 通过在表格数据流(TDS)数据包中指定 ID = 1 来调用。 Transact-SQL 语法约定 语法 syntaxsql 复制 sp_cursor cursor , optype , rownum , table [ , value [ ...n ] ] [ ; ] 参数 重要 扩展...
SQL Server supports two methods for requesting a cursor: Transact-SQL The Transact-SQL language supports a syntax for using cursors modeled after the ISO cursor syntax. Database application programming interface (API) cursor functions SQL Server supports the cursor functionality of these database APIs...
Transact-SQL 扩展语句(Transact-SQL Extended Syntax):declare cursor_namecursor[ local| global][ forward_only |scroll][ static| keyset| dynamic | fast_forward ][ read_only | scroll_locks | optimistic ][ type_warning ]for select_statement[ for update[ of column_name [ ,...n ] ] ] ...
适用于: SQL Server Azure SQL 数据库 Azure SQL 托管实例 对于给定参数,CURSOR_STATUS 显示游标声明是否已返回游标或结果集。 Transact-SQL 语法约定 语法 syntaxsql 复制 CURSOR_STATUS ( { 'local' , 'cursor_name' } | { 'global' , 'cursor_name' } | { 'variable' , 'cursor_variable' } ) ...
DECLARE CURSOR 既接受基于 ISO 标准的语法,也接受使用一组 Transact-SQL 扩展的语法。 Transact-SQL 语法约定 语法 ISO 语法: syntaxsql 复制 DECLARE cursor_name [ INSENSITIVE ] [ SCROLL ] CURSOR FOR select_statement [ FOR { READ_ONLY | UPDATE [ OF column_name [ , ...n ] ] } ] [ ; ]...
The Transact-SQL language supports a syntax for using cursors modeled after the ISO cursor syntax. Database application programming interface (API) cursor functions SQL Server supports the cursor functionality of these database APIs: ADO (Microsoft ActiveX Data Object) OLE DB ODBC (Open Database...
DECLARE CURSOR 既接受基于 ISO 标准的语法,也接受使用一组 Transact-SQL 扩展的语法。 Transact-SQL 语法约定 语法 ISO 语法: syntaxsql 复制 DECLARE cursor_name [ INSENSITIVE ] [ SCROLL ] CURSOR FOR select_statement [ FOR { READ_ONLY | UPDATE [ OF column_name [ , ...n ] ] } ] [ ; ]...
syntaxsql sp_cursorfetchcursor [ , fetchtype [ , rownum [ , nrows ] ] ] [ ; ] 引數 重要 擴充預存程式的自變數必須依特定順序輸入,如語法一節所述。 如果參數依序輸入,就會發生錯誤訊息。 cursor 由SQL Server 產生的句柄值,並由傳sp_cursoropen回。cursor是呼叫int輸入值的必要參數。 如需詳細資訊...