Home

Submit

Source

Feeds

Home » ASP » Scripts ::

ASP Scripts
This sql script creates a sample table to use for some code snipts. First create a database and run this code in Query Analyzer.
Related Tutorials
ASP Database Integration
Deleting Records Using Stored procedure
ASP / Database Integration
We will continue working on our sample table. Now we will delete some records using stored procuder. To work on the code create a sample database and run this sql script.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
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.

Site: www.aspemporium.com Report - View Tutorial

ASP Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
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 .

Site: www.dotnetindex.com Report - View Tutorial

ASP Miscellaneous
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!).

Site: dypso.free.fr Report - View Tutorial

ASP Database Integration
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.)

Site: www.15seconds.com Report - View Tutorial

ASP Date and Time
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Counters
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

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
SQL In Simple English - Part II
ASP / Database Integration
This article mainly deals with SQL Joins and SQL sub-queries. Both of these are extremely useful SQL constructs and should be learnt by all beginners.

Site: stardeveloper.com Report - View Tutorial

ASP Security
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
Uploading Images to Database Using Persist AspUpload
ASP / Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP File Operations
Uploading Images to Database Using Persist AspUpload
ASP / File Operations
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.

Site: www.dotnetindex.com Report - View Tutorial

ASP Database Integration
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.

Site: www.asp101.com Report - View Tutorial

ASP Database Integration
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.

Site: www.dotnetindex.com Report - View Tutorial

 
Site Search

 
Categories
2D Graphics 3D Graphics Office Applications Databases Desktop Programming Web Development
 
Advertisement