Adding Records Using Stored procedure ASP / Database Integration
This code source is focusing on creating a simple stored procuder to add items into a SQL Server. If you use stored procuders, your applications will work faster and performance will be better.
Fun With Stored Procedures ASP / Database Integration
A stored procedure is nothing more than an sql statement stored inside a database. The database can be SQL Server or MS Access as well as others ... A stored procedure is compiled by your database (for the most part) one time, when it is entered. This results in faster database executions and overall performance updates... as an added bonus, it further separates the sql statement from your asp leaving you with more readable code. So let's get on with it.
Displaying Records Using Stored procedure ASP / Database Integration
We will get results form a table using stored procedure. Stored procedures work faster and increase the performance. Stored procedures stored at SQL servers and we can call them in an ASP file.
Updating Records Using Stored procedure ASP / Database Integration
This code source is focusing on creating a simple stored procudure updating records in a table. Code is simple and clear, you may modify this code to use in your applications. To work on the code create a sample database and run this sql script .
Create a PDF from a stored procedure ASP / Miscellaneous
This article explains how to create a stored procedure and to call it from ASP or directly from SQL Server. The stored procedure will in turn create a simple column based report in PDF without using any external tools or libraries (and their associated licensing costs!).
Interrogating a Stored Procedure with ADO ASP / Database Integration
This article shows how to use the refresh method of the ADO Parameters collection to interrogate a stored procedure. You may already have experience using ADOX or SQL-DMO to accomplish this, but please keep in mind that the method displayed here is meant to be simple enough that anyone with ADO experience can use it. (ADOX and SQL-DMO will be addressed later.)
Returning Month of Date in an SQL Table ASP / Date and Time
This is an useful but not known functions. If you wish to learn month of date stored in a database, you may use this function placing in a 'SELECT' sql statement.
Hit counter Using Stored Procedure ASP / Counters
This simple counter uses only one stored procedure to update and display hits. So it uses less server memory. The database back-end is SQL Server. But you may easily modify procedure to use with MS Access
Database-Driven Login Script ASP / Security
This script lets you to build a login script. User can login a password protected page using his/her own login username and password. All usernames and passwords stored in a MS-Access database.
Using SQL-DMO To Backup and Verify a Database ASP / Database Integration
This article "Using the SQL Distributed Management Objects", provided an overview of SQL-DMO. This article expands upon those concepts by showing you how to use SQL-DMO to create an Active Server Page application to backup and verify a SQL Server database.
How many records do I have in database table? ASP / Database Integration
Sometimes we worry about limits of database table and we need to know how manay recods we have. In ASP we could count all recods using a loop. But if we have a small piece of knowledge about SQL script, our script works better and faster.