This short tutorial demonstrates how to insert data into a SQL database using SQL statements.

This is a brief and very useful tutorial on creating and using stored procedures with your asp applications. 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, and it further separates the sql statement from your asp leaving you with more readable code. This tutorial describes: What is a stored procedure?, Writing stored procedures, Getting the stored procedure into the database, Calling stored procedures in ASP pages, and Modifying and removing stored procedures.

This is a set of ASP examples/tutorials that demonstrate exactly how to use ASP with a database. Topics include: Using ADO To Add A New Record, Using ADO To Update An Existing Record, Using An Update Query To Modify An Existing Record, Using Delete Statement to Delete Records, Using A Select Statement (With A Loop), and ACCESS DATABASES ( DSN vs DSN-LESS).

Active Server Pages allow us an easy means of querying and updating a database from a webpage. This article describes the basics of using this technique in a nutshell. The examples given here utilize a Microsoft Access database, but the principles elucidated apply equally well to ASP integration with other databaes.

This tutorial helps you to understand: Connecting ASP Pages to MS Access Databases Persisting Data to MS Access Databases Protecting Data in SQL Statements

This tutorial helps you to understand: Connecting ASP Pages to MS Access Databases Persisting Data to MS Access Databases Protecting Data in SQL Statements

Filter method is very useful working with large datasets. You might need to put only some records from your database but you should select all data from database. Fileter method is advantage working on recordsets after querying on SQL command.

Delete a record from your database quickly and easily without having to use a recordset. Deleting a record from a database table is a simple task. Answer four questions below and click submit. The sql statement will be generated for you.

If you have an SQL database set up with your web host, a useful tip to know is how to connect to your SQL database via Enterprise Manager. The advantage of knowing how to do this is that you will be able to manage your SQL Server database via Enterprise Manager over TCP/IP, yourself.

This article will show you two different methods that you can use to connect to a Microsoft SQL Server 2000 database: System DSN's and the OLEDB connection string. It will also explain the positives and negatives of each method, along with some examples to get you started.