MSSQL and Character Set Issues
One of the most troubling parts of ASP and SQL for new programmers can be how to handle apostrophes and other special characters. Here is […]
SQL Commands
Joining Tables in SQL
Do you have two tables, and want to be able to calculate totals and merge information across them? Just join them together! This isn’t even […]
MySQL Optimizing Tips
If you are working with a MySQL database, it is important to optimize the database so it runs as quickly as possible. Here are some […]
Create a Table with SQL Syntax
Need to create a table to put data in? It’s very easy to put together SQL Syntax to build the table to store your newsletter […]
Selecting from a SQL Database
You understand the basics of using ASP, including loops and requests. Now you want to use this knowledge to select information out of a database. […]
Handling Apostrophes in ASP and SQL
An important step when using character data in SQL and ASP is making sure that any apostrophes (‘) in the data doesn’t interfere with your […]
Syntax of a SQL Statement
The most common thing to do with ASP is show information stored in a database. Here are the basics of the SQL Select statement, to […]
Selecting All Rows from a SQL Table
There are many times that you will want to select all rows from a given database table. How do you move through the records, and […]