一些在SQL帮助中找不到的系统存储过程－System stored procedures

Syntax
sp_cursor [@cursor =] cursor_handle,
    [@optype =] optype,
    [@rownum =] rownum,
    [@table =] 'table'
    {, [@param1 =] value1 [,...n] }

Arguments
[@cursor =] cursor_handle
Is a cursor handle obtained by calling sp_cursorcreate. cursor_handle is int, with no default.
[@optype =] optype
Is a the operation to perform. optype is int, with no default and can be one of these values.

Value Description
1 Update row (?).
4 Insert row.
33 Update row.
34 Delete row.

[@rownum =] rownum
Is the number of the row to update in the fetch cache. rownum is int, with no default.
[@table =] 'table'
Is the name of the table to update (an empty character string seems to be ok). table is sysname, with no default.
Return Code Values
0 (success) or 1 (failure).

Result Sets
None.

Permissions
Execute permissions default to the public role.

Example
USE pubs

-- Create a dynamc cursor

DECLARE @cursor INT

EXEC sp_cursoropen @cursor OUTPUT, 'SELECT * FROM myTable', 2, 8193

-- Fetch the next 2 lines; this puts lines 1 and 2 in the fetch buffer

EXEC sp_cursorfetch @cursor, 2, 0, 2

-- Update the second line in the fetch buffer

EXEC sp_cursor @cursor, 33, 2, '', @intCol=5, @charCol='x'

-- Close the cursor

EXEC sp_cursorclose @cursor

sp_cursorprepare
Used to prepare a parameterized cursor statement.

Syntax
sp_cursorprepare [@cursor =] statement_handle OUTPUT,
     [@paramdef =] N'parameter_name data_type [,...n]',
     [@stmt =] N'stmt',
     [@options =] options,
    [, [@scrollopt =] scroll_options OUTPUT]

上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] [12] 下一页

复制本页网址和标题，发送给你QQ/Msn的好友一起分享

上一篇:WindowsXP+IIS+PHP5+MySQL5+Zend+GD库+phpMyAdmin+PHPWind 5.3 安装教程

下一篇:php+mysql 获取数据库中的记录(特别是高效的分页功能)