logo
g
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies

dailyclick
Bored? Games!
Nutrition
Postcards
Take a Quiz
Rate My Photo

new
Houseplants
Romance Movies
Creativity
Family Travel
Southwest USA
Irish Culture
Home Finance


dailyclick
All times in EST

Full Schedule
g
g ASP Site

BellaOnline's ASP Editor

g
SQL DB Code

Here are examples and instructions for how to write proper SQL code for your database.

Advanced SQL Update Command: Using Two Tables star
There are times that you need to update one SQL database table, and want to use values from another table to do the update with. Here is how you would do that in ASP.

Create a Table with SQL Syntax star
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 members, poll votes, or more.

DELETE - Deleting in SQL star
One of the most dangerous commands you can issue is the DELETE command. Be very cautious that you use this command properly, lest you find your entire table wiped out.

Handling Apostrophes in ASP and SQL star
One of the most troubling parts of ASP and SQL for new programmers can be how to handle apostrophes. Here is a guide to getting those apostrophes working properly.

Inserting Into a Database with ASP star
The INSERT command is very commonly used in ASP to add rows into a SQL database. Here is the syntax for inserting into your tables.

Joining Tables in SQL star
Do you have two tables, and want to be able to calculate totals and merge information across them? Just join them together!

Like Statement in SQL - Inexact Wildcard Matches star
If you´re writing a SQL statement, sometimes you want wildcarded matches. The LIKE command lets you get matches that are similar to a phrase you supply.

MAX - Selecting a Maximum Number in SQL star
SQL provides an easy to use method of determining the largest, or maximum, number in a database. This can get you the largest salary, next available ID number, and much more.

MIN - Selecting a Minimum Number in SQL star
SQL has many handy, built in functions. One of those is MIN, which gets you the smallest number in a set.

MoveNext Record Set Function star
When you´re working with a set of records in ASP, you want some way to move from record to record. The MoveNext function lets you do that.

RecordCount and Count star
If you´re trying to figure out how many records are in a given SQL result set, you can use either the RecordCount or Count command. Both work in different ways.

Selecting All Rows from a Table star
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 display the data?

Selecting from a Database star
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. Here´s how you do it!

Syntax of a SQL Select Statement star
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 get that information.

Updating a SQL Database with ASP star
Often, you´ll want to use ASP to update a database record using SQL. Here is how it is done!

ASP Homepage | Editor's Picks Articles | Top Ten Articles | ASP Site Map

Add SQL+DB+Code to Twitter Add SQL+DB+Code to Facebook Add SQL+DB+Code to MySpace Add SQL+DB+Code to Del.icio.us Digg SQL+DB+Code Add SQL+DB+Code to Yahoo My Web Add SQL+DB+Code to Google Bookmarks Add SQL+DB+Code to Stumbleupon Add SQL+DB+Code to Reddit

g

Want to Suggest a Link?
Think your link belongs here? Use the contact page to let this editor know.

For FREE email updates, subscribe to the ASP Newsletter


Past Issues

g features
Best uses for RSS

RSS and its future.

Force Download Dialog box with ASP

Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter


vote
Poetry
Daily
Weekly
Monthly
Less than Monthly



BellaOnline on Facebook
g


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2014 Minerva WebWorks LLC. All rights reserved.


BellaOnline Editor