Author(s)

Baosheng Qi

Corresponding Author

Baosheng Qi

ABSTRACT

Using the techniques in the SQL Server, such as query, stored procedure and cursor etc, carried out the student’s result Table to gather to show the problem, its logic carries to complete in the database server, reducing the network data discharge; Moreover, in stored procedure, make use of the template, the system Table to delete in time the temporary Tables, the data that avoided the futility piles up in the database.

KEYWORDS

Student's grades, Query, Stored procedure, Cursor