Upload Code
loading-left
loading loading loading
loading-right

Loading

Profile
No self-introduction
codes (2)
Application of the cursor in the autonomous develo
no vote
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
cshlj
2016-08-23
1
1
Using T-SQL to write a stored procedure
no vote
Application background Introduce the basic usage of T-SQL stored procedure, for beginners learning to use. A stored procedure is a set of Transact-SQL statements precompiled, as a unit of storage on the server and executed on the server. The stored procedure can take input, output parameters, return values. With the advantages of stored procedures are as follows:(1) the safety of stored procedure can force the application, can prevent SQL injection attacks.(2) the stored procedure can greatly reduce network traffic. (3) the stored procedure is registered in the server, the implementation of high efficiency.(4) the storage process greatly improves the maintainability of the application and the design efficiency. Key Technology In the SQL defined in Server 2008, execute, modify the stored procedure. The use of create procedure or create proc stored procedure, use exec or execute to execute a stored procedure, the use of alter proc or alter pro
cshlj
2016-08-23
0
1
No more~