Members

Technology Zones

IBM Learning Center

Articles

Hosted By

MaximumASP

Info
Rated
Read 22,823 times
4 comments

Contents

Downloads

Related Categories

SQL In Simple English - Introduction

kiranpai

Introduction

I have found that many articles found on the net are good and detailed but they are not really friendly to novice programmers.

In my article the topic is presented as a Q&A session. Most of the questions are the ones that most novices would like to ask. And the Answers are present in very simple language. This approach is excellent and readers who aren't familiar with the technology seem to understand the article in 1 reading itself.

I have kept the article totally language neutral. Hence programmers using any language and who want to do database programming will find it useful.

Comments

Read Comments | Post Comment

  • SQL

    Posted by randombloke on 10 Jun 2003

    Hi I would first like to say your site has been really helpful to me.

    When using ASP to display database information in a web page you might use

    [courier new]
    Set adoConnect = Server.CreateObje...

  • Posted by haironi on 06 Mar 2002

    sorry probably it has been too long and may be you've got the answer but try this
    select * from table where date> #2/2/1979#

  • this should work

    Posted by kiranpai on 26 Feb 2002

    hi..
    check this ... should work

    select * from table_name where DateOfBirth
    try using TO_DATE with the date you want.. i have used this before in this manner.. ...

  • SQL

    Posted by rusty on 26 Feb 2002

    Thanks, very helpful.

    What about dates though? What is the code for finding dates using the SELECT statement eg 'SELECT from * WHERE DateOfBirth < 10/9/76 10:01:10', I can't get it to work.