Looking at a strange phenomenon of SQL script execution

Source: Internet
Author: User
Tags execution
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.



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.