Script | Execution when we make up a piece of code, the execution time takes several 10 seconds or more, such as a cursor program that accesses all the records and changes them. I
When I found out that all the records I had done in the Query Analyzer tool would change as I wanted, the program would appear only to update the previous one when switching to the following environments
Some of the strange things that are recorded:
1. When direct SQL is executed directly with the Con.execute statement in ASP
2. When a stored procedure that invokes the corresponding code directly in the ASP is Con.execute
3. When using command to invoke stored procedures with no parameters in the ASP
4. When a stored procedure with no output parameter is invoked in ASP
An inadvertent operation, I found that when using a stored procedure with an output parameter, the program can perform very little time and make all records effective. It's mine
The aim is to reach, but what is this? Why is the SQL statement only executed in 4 cases above and then stopped?
Note: The output parameter can be as long as there is one, regardless of whether it is useful in the stored procedure.