NEW LISTINGS 
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
HOT LISTINGS
TOP RATED
EDITOR PICK
ADD A LISTING
UPDATE A LISTING
GET RATED
UPGRADE A LISTING
Fun With Stored Procedures?
2615
Fun With Stored Procedures?
http://www.aspemporium.com/aspEmporium/tutorials/StoredProcedures.asp
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.
ASP > Tips and Tutorials > Database-related
Oct 10, 2006
Write a Review
Add to My Favorite
Refer it to Friend
Report Broken Link
| |
|
||
| Bookmark Fun With Stored Procedures?: |
|||
Other links at ASP > Tips and Tutorials > Database-related
This page demonstrates the capabilities how to write an ASCII comma-delimited file from a SQL statement.
Category:
You can test the demo for dynamically dependent dropdown lists here:
http://www.jamesfarrow.com/codeexamples/Double_Listbox_Populated_From_DB/
http://www.jamesfarrow.com/codeexamples/Double_Listbox_Populated_From_DB/
Category:
sample code below and edit the tables to match yours.
You can store images in a Database to later access them. To do that,
you have to use the following code to get the image from the database.
You can store images in a Database to later access them. To do that,
you have to use the following code to get the image from the database.
Category:
These examples demonstrate exactly how to use ASP with a database.
I think these SIMPLE examples would have helped me out a lot when I started out.
I think these SIMPLE examples would have helped me out a lot when I started out.
Category:
Several State and Federal contracts that I have worked on in the past have wanted to keep track of all changes to a particular record, such as who modified the record, what kind of modification took place, and when the record modification occurred. I decided to solve this problem with triggers because I wanted to capture every action that occurred on a particular table. For those unfamiliar with triggers, a trigger is a database-event that fires when a particular action occurs. For example, an INSERT trigger would fire when a particular database table has a record inserted. For a more in-depth examination of triggers, be sure to read
Category:
Main Category
200
2047
830
286
175
1804
1573
913
1177
7596
70
919
60
2247
175
Join Mailing List
Joining mailing list will entitle you
to receive occasional emails informing you of news and
updates to the site and any special offers that may be
of interest to you.
Top 10
Directory Statistics
Links: 20048
Categories: 1275
Registered Users: 789
Mailing List Subscribers: 2049
Unique Outgoing Hits: 234591
Pagerank Statistics
PHP News