Recommended: Analyze date formatting issues in Asp For the date stored in the date and time type field of the access database, the effect of reading the display directly from the database is time-sensitive, such as 2009-06-1318:00. What should I do if I just want to display the date? Vbscript has a function FormatDateTime(). It is described as follows: Returns the expression, which has been formatted as a date or time. For
I have always used ASP+ACCESS to write web pages, and I have never used stored procedures. All additions, deletions, and modifications are written in ASP to execute programs. There is a lot of code. There is no feeling when the data volume is small, and it is quite fast. But when the data volume is large, I will record and query it. Especially when the page is not paginated, the situation will appear. The speed is very slow and it takes more than 10 seconds to react. So I thought of using SQL stored procedures to simplify the code and speed up the execution of the program!1.ASP calls stored procedures
First, I will create a database called it in SQL. I won’t talk about how to build it. This is simple, you can tell at a glance. Then build a table in the library and write a few data records as follows:
Open the query analyzer:
Write the following statement inside and click the green button to execute it:
If you look at the stored procedure in the database, there is an additional stored procedure called upGetUserName, which indicates that the stored procedure has been successfully established. If not, try to refresh it.
Share: How to make ASP search keyword highlight It is very convenient to use ASP to implement the functions of search engines, but how to implement intelligent searches similar to 3721? For example, when "Chinese People" is entered in the search condition box, it will be automatically extracted from it.
2 pages in total Previous page 12 Next page