Add to Favorites    Make Home Page 28591 Online  
 Language Categories  
 Our Services  

ASP » Tips and Tutorials » Database-related » Using Stored Procedures

A D V E R T I S E M E N T

Search Projects & Source Codes:



Title Using Stored Procedures
Platform Windows XP, IIS
Price Free
Author Visit Author Website
Website Visit Website of - Using Stored Procedures
Category ASP » Tips and Tutorials » Database-related
Hits 716
Description A stored procedure is like a map to commonly requested information, which can speed things up. This is because stored procedures are cached in the server.

A D V E R T I S E M E N T




Google Groups Subscribe to SourceCodesWorld - Techies Talk
Email:

Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.


Scripts Related to - Using Stored Procedures

Script Name

Using GetRows To Get All Records From Table

Following example, extracts all of the records in a database table and stores into a 2-dimensional array. This gives you an advantages to modify and work on data.

Uploading Images to Database Using Persist AspUpload

You can upload your images to MS-SQL server with this simple script. To upload a picture to sql database, be sure Persist AspUpoad installed in you server.

How to Get Identity of New Record

Sometimes you need the learn new record number while your are adding a new record. Following example adds a new records to a table and gets the the autonumber or identity of that records.

Using SUM Function in An SQL Statement

Sum function can be used for to get the sum of a numeric expression evaluated over a set. This function must be placed in an SQL statement. Following example will return the sum of ratings in articles.

Compacting an Access database from ASP code

This source code can compact and repair your MS-Access database files. If you compact your access files regularly, it will work more faster and secure. Also you will save some hard disk space.

Executing Transact-SQL UPDATE statement

In this example, we will edit some records from a database. This source code helps us to edit records to database without slowing down database

Executing Transact-SQL INSERT statement

In this example, we will add some records to a database. This source code helps us to adding records to database without slowing down database.

Counting Records In A Database Table

We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine. Count of records will be first value of resultset.

Executing Transact-SQL DELETE statement

In this example, we will delete some records from a database. This source code helps us to deleting records to database without slowing down database.

Simple database techniques

When you start using ASP, you will begin working with databases. Interacting with databases can be very important. In this tutorial, we will be using a Microsoft Access Database along with technologies like ADO and the Connection and Recordset objects.

Google Search

Google

Source Codes World.com is a part of Vyom Network.

Vyom Network : Web Hosting | Dedicated Server | Free SMS, GRE, GMAT, MBA | Online Exams | Freshers Jobs | Software Downloads | Interview Questions | Jobs, Discussions | Placement Papers | Free eBooks | Free eBooks | Free Business Info | Interview Questions | Free Tutorials | Arabic, French, German | IAS Preparation | Jokes, Songs, Fun | Free Classifieds | Free Recipes | Free Downloads | Bangalore Info | Tech Solutions | Project Outsourcing, Web Hosting | GATE Preparation | MBA Preparation | SAP Info | Software Testing | Google Logo Maker | Freshers Jobs

Sitemap | Privacy Policy | Terms and Conditions
Copyright ©2003-2019 SourceCodesWorld.com, All Rights Reserved.
Page URL: http://www.sourcecodesworld.com/scripts/Using-Stored-Procedures-2351/Default.asp


Download Yahoo Messenger | Placement Papers | Free SMS | C Interview Questions | C++ Interview Questions | Quick2Host Review


 Advertisements