Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > SQL 必知必会笔记19使用游标

SQL 必知必会笔记19使用游标

WBOY
Release： 2016-06-07 17:38:37
Original
1085 people have browsed it

游标（cursor）是一个存储在DBMS服务器上的数据库查询，它不是一条SELECT语句，而是被该语句检索出来的结果集。在存储了游标之后，应用程序可以根据需要滚动或浏览其中的数据。 使用游标 使用游标的步骤： 1. 创建游标 在SQL Server中使用DECLARE命名游标，

游标（cursor）是一个存储在DBMS服务器上的数据库查询，它不是一条SELECT语句，而是被该语句检索出来的结果集。在存储了游标之后，，应用程序可以根据需要滚动或浏览其中的数据。

使用游标

使用游标的步骤：

 

1. 创建游标

在SQL Server中使用DECLARE命名游标，并定义相应的SELECT语句，根据需要带WHERE和其他子句,示例如下：

Customers

Related labels：
use Must know cursor notes
source：php.cn
Previous article： 数据分布影响exp条件导出变慢的问题处理 Next article： 回收数据表Ⅰ
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
From 2024-04-06 21:23:40
0
2
530
Sudoku checker not working? Can anyone help me identify the error? I tried everything on the online editor but still get the error. But when I do this on VSC...
From 2024-04-06 21:21:07
0
1
474
How to solve the mysterious white space at the bottom of the page in CSS I'm trying to build a simple webpage using Bootstrap and D3, but I don't know how to get r...
From 2024-04-06 20:22:15
0
1
454
Problems encountered when using opentbs to generate odt files: values ​​of the same key are displayed in the same row instead of separate columns. I'm using a library called OpenTbs to create odt using PHP, I'm using it because columns a...
From 2024-04-06 20:18:18
0
1
483
for loop randomly goes from 1 to 0 Basically, every time the page is refreshed, the for loop has the potential to change from...
From 2024-04-06 16:48:14
0
1
393
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template