Subscribe
Tutorial search

ASP Sql Tutorials


Sort by:
MS SQL Stored Procedures and Classic ASP
MS SQL Stored Procedures and Classic ASP
Stored procedures offer an extra layer of security when interacting with a SQL database, they allow you to reuse frequently used database queries whilst avoiding duplicating statements throughout your site, and they offer a big performance increase over passing a string of SQL to the server.
Difficulty:
Preventing SQL Injection Attacks in Classic ASP
Preventing SQL Injection Attacks in Classic ASP
The term 'SQL Injection' means to inject malicious SQL statement(s) in an otherwise regular SQL to get access to secure data on a website. In this article, we will examine how SQL injection attacks are carried out and what programming techniques can be used to prevent them. While we will assume classic ASP pages and the backend SQL Server database to demonstrate the method and means of prevention, the concept is equally applicable to other web programming technologies and database systems.
Difficulty:
Executing Transact-SQL UPDATE statement
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 .
Difficulty:
Executing Transact-SQL INSERT statement
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. .
Difficulty:
Executing Transact-SQL DELETE statement
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.
Difficulty:
Database Search Engine
Database Search Engine
This sample ASP script we will search a custom query in an SQL database. We will use two custom script in one page and will take query results divided in pages. before starting to use this script, you must modify sql query and database connection.
Difficulty:
Executing Transact-SQL INSERT statement
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.
Difficulty:
Executing Transact-SQL DELETE statement
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.
Difficulty:
Access and SQL Server DSN-LESS connections
Access and SQL Server DSN-LESS connections
There are a few different ways to connect to an Access database using a DSN-LESS connection. You can use the Access driver, an OLEDB provider connection, a physical path or a virtual path. Here is an example of each as well as a DSN-LESS SQL Server connection.
Difficulty:
Edit records with sql statements
Edit records with sql statements
Learn how to edit records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
Difficulty:
Add records with sql statments
Add records with sql statments
Learn how to add records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
Difficulty:
Delete records with sql statements
Delete records with sql statements
Learn how to delete records with an SQL instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection.
Difficulty:
Connecting to your SQL Database
Connecting to your SQL Database
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.
Difficulty:
SQL In Simple English - Part 1
SQL In Simple English - Part 1
Article describes what is SQL? what it is used for? how to SELECT, INSERT, UPDATE and DELETE records from the database? and more.
Difficulty:
SQL In Simple English - Part II
SQL In Simple English - Part II
This is the second article in this series. 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.
Difficulty:
Search Term(s) (1): sql