Home » Source Code » Application of the cursor in the autonomous development of online sentence test system

Application of the cursor in the autonomous development of online sentence test system

cshlj
2015-09-07 07:25:20
The author
View(s):
Download(s): 0
Point (s): 1 
Category Category:
SQL ServerSQL Server Transact-SQLTransact-SQL

Description

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 DEALLOCATE statement.
Sponsored links

File list

Tips: You can preview the content of files by clicking file names^_^
Name Size Date
testCursor.sql2.34 kB2015-09-07|14:37
...
Sponsored links

Comments

(Add your comment, get 0.1 Point)
Minimum:15 words, Maximum:160 words
  • 1
  • Page 1
  • Total 1

Application of the cursor in the autonomous development of online sentence test system (1.05 kB)

Need 1 Point(s)
Your Point (s)

Your Point isn't enough.

Get 22 Point immediately by PayPal

Point will be added to your account automatically after the transaction.

More(Debit card / Credit card / PayPal Credit / Online Banking)

Submit your source codes. Get more Points

LOGIN

Don't have an account? Register now
Need any help?
Mail to: support@codeforge.com

切换到中文版?

CodeForge Chinese Version
CodeForge English Version

Where are you going?

^_^"Oops ...

Sorry!This guy is mysterious, its blog hasn't been opened, try another, please!
OK

Warm tip!

CodeForge to FavoriteFavorite by Ctrl+D