DECLARECURSOR

  • 网络创建游标

网络释义

1.
创建游标
T-SQL技术开发实用大全:基于SQL Server... ... 9.8 删除视图— —DROP VIEW 10.2 创建游标— —DECLARECURSOR 10.3 打 …
www.tushucheng.com|基于2个网页

例句

释义:
全部全部,创建游标创建游标
类别:全部全部,口语口语,书面语书面语,标题标题,技术技术
来源:全部全部,字典字典,网络网络
难度:全部全部,简单简单,中等中等,难难
1.
An application should only execute DECLARE CURSOR if it has set all the API cursor attributes back to their defaults.
应用程序只有在将所有的API游标特性设置回默认值后，才可以执行DECLARECURSOR。
msdn2.microsoft.com
2.
DECLARE CURSOR permissions default to any user that has SELECT permissions on the views, tables, and columns used in the cursor.
默认情况下，将DECLARECURSOR权限授予对游标中所使用的视图、表和列具有SELECT权限的任何用户。
msdn2.microsoft.com
3.
The DECLARE CURSOR statement is the root of the graphical execution plan tree, with its related statement as a child or node.
DECLARECURSOR语句是图形执行计划树的根，与之相关的语句为子级或节点。
msdn2.microsoft.com
4.
Is the name of a cursor created by a DECLARE CURSOR statement that either has the LOCAL keyword or that defaulted to LOCAL.
由具有LOCAL关键字或默认设置为LOCAL的DECLARECURSOR语句创建的游标名称。
msdn2.microsoft.com
5.
LOCAL specifies that the cursor name is LOCAL to the stored procedure, trigger, or batch containing the DECLARE CURSOR statement.
LOCAL指定游标名称对含有DECLARECURSOR语句的存储过程、触发器或批处理是局部性的。
msdn2.microsoft.com
6.
You cannot use the COMPUTE clause when the SELECT statement is part of a DECLARE CURSOR statement.
当SELECT语句是DECLARECURSOR语句的一部分时，不能使用COMPUTE子句。
msdn2.microsoft.com
7.
The DECLARE CURSOR statement declares a cursor with the specified name for a SELECT statement or a CALL statement.
DECLARECURSOR语句用SELECT语句或CALL语句的指定名称声明游标。
www.ianywhere.com
8.
The first form of the DECLARE CURSOR statement uses the SQL-92 syntax for declaring cursor behaviors.
DECLARECURSOR语句的第一种格式使用SQL-92语法声明游标行为。
msdn2.microsoft.com
9.
The FETCH statements return the value for the column specified in the DECLARE CURSOR as a single-row result set.
FETCH语句以单行结果集形式返回在DECLARECURSOR中指定的列的值。
technet.microsoft.com
10.
The DECLARE CURSOR statement has been extended; thus you can specify the four cursor types for Transact-SQL cursors.
已经扩展了DECLARECURSOR语句，这样您就可以为Transact-SQL游标指定四种游标类型。
msdn2.microsoft.com