Application of the cursor in the autonomous develo
2016-08-23
1 0 0
no vote
Other
Earn points
Application background
Judge Online (referred to as OJ) generally refers to the international students in the program design contest and other forms of programming contest to evaluate the correctness and efficiency of the program and the program is based on the network environment. Discusses the application of cursor in OJ. The discussion is focused on the in the test account were randomly assigned in a stored procedure, and in answer to remove the trigger by vernier to achieve progressive access data.Key Technology
Application of a cursor mechanism to a line or a branch in a relationship table. Using the SQL Transact cursor, the typical process of using SQL Transact cursor in stored procedure or trigger:A. use the CURSOR DECLARE statement to declare the SQL Transact cursor;B. uses the OPEN statement to open the cursor;C. uses the FETCH statement to extract a single row;D. closes and releases the cursor using the CLOSE statement and the DEALLOCA系统
开发
应用
在线
自主
游标
Related Source Codes
System synchronization (third-order system trackin
0
0
no vote
C # Bookstore System
0
0
no vote
Source code for system time acquisition and time d
0
0
no vote
Database student table
0
0
no vote
Hasbier system based on wireless sensor
0
0
no vote
No comment