Members

Technology Zones

Articles

Hosted By

MaximumASP

Info
Rated
Read 169,120 times
5 comments

Contents

Related Categories

SQL Commands - Introduction

James Crowley

Introduction

SQL statements are used by Access, ADO, Oracle, Informix, and not suprisingly, MS SQL server. In short, if you use databases, be it in VB, ASP, FoxPro, Access or anything else, at some stage you will need to know SQL. SQL, or Structured Query Language gives you complete control over databases, creating, deleting, modifying, adding, reading, sorting, querying and much more beside.

In this tutorial, we will cover the basic statements letting you request, add, modify and delete records, which are the commands you are most likely to use.

*** If you are using VB, ASP or Access, you can use the Execute method of a Connection object to run a SQL command ***

James first started writing tutorials on Visual Basic in 1999 whilst starting this website (then known as VB Web). Since then, the site has grown rapidly, and James has written numerous tutorials, articles and reviews on VB, PHP, ASP and C#. In October 2003, James formed the company Developer Fusion Ltd, which owns this website, and also offers various development services. In his spare time, he's a 3rd year undergraduate studying Computer Science in the UK. He's also a Visual Basic MVP.

Comments

Read Comments | Post Comment

  • Check for Failed SQL Query

    Posted by zible on 24 Jan 2007

    This seems simple, yet I can't find how you do this. I need to run a query in VB on a very simple database. There is the possibility that the query would be unsuccessfull, and if so I need to do ot...

  • Sql Info

    Posted by darshan on 25 Apr 2005

    you need to fire sql statement like this
    select idno, name, email, return from [table_name] where [your_condition]

    this will return record set lets say "rs" is object of recordset
    then you will n...

  • Another database issue

    Posted by Abzmoh2007 on 11 Mar 2004

    Basically am trying to search a database by getting an input from the users selection on a list.
    the list contains names of countries and when i click that search button, how can i get the result of...

  • Filling Table With Datagrid

    Posted by NightChillz on 23 Dec 2003

    hey, i see how i can fill a datagrid with data from an sql table, but i am having trouble figuring out how to do the exact opposite, take data from a datagrid and fill an sql table with it/overriding ...

  • update data

    Posted by tomoko on 26 Nov 2003

    hi,
    pls help as i'm new in asp. i'm developing the administrative part of a website for my project. i'm having trouble with the "updating data" part. for example, i have done the 'add staff' and "de...