Results 1 to 3 of 3

Thread: SQL Queries

  1. #1

    Thread Starter
    New Member
    Join Date
    Mar 2006
    Posts
    12

    SQL Queries

    here is my problem, i need to find tutorials onn advanced SQL queries. here is were i get a problem, I wrire this querie in .Net to access info from a Access DB. i try set a condition but i get an error. here is an example of what im trying to do.

    INSERT INTO TABLE1(NAME) VALUES('"name"') WHERE(AGE="'21'")

    please advise

  2. #2
    Shared Member
    Join Date
    May 2005
    Location
    Kashmir, India
    Posts
    2,277

    Re: SQL Queries

    Insert statements do not use conditions. If you want to update information in the database then you should be using Update Statements.

    I always find W3Schools tutorials short and sweet and easy to understand
    http://www.w3schools.com/sql/default.asp
    Use [code] source code here[/code] tags when you post source code.

    My Articles

  3. #3
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    105,448

    Re: SQL Queries

    There's another SQL tutorial link in my signature. I'm not trying to be rude here but that type of SQL is not advanced. I don't even really consider myself at the intermediate level when it comes to SQL. I have the latest edition of "SQL in a Nutshell" and it's almost 700 pages. And that's supposed to be a nutshell? I'd hate to see the extended version. Select, Insert, Update and Delete are as simple as it gets. To extend on what Shuja Ali said, a WHERE clause specifies conditions on existing data. Select, Update and Delete all act on existing data and can therefore have a WHERE clause, but Insert cannot because it is adding new data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width