Help!!!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ghostrider
    New Member
    • Jan 2007
    • 34

    #1

    Help!!!

    Okay I'm totally new to SQL, I need to write a program that has 2 tables, can any one help me get started?
  • Infide
    New Member
    • Jul 2007
    • 28

    #2
    Originally posted by ghostrider
    Okay I'm totally new to SQL, I need to write a program that has 2 tables, can any one help me get started?
    Can you give us any more specifics?

    What kind of program are you writing, what are the specs? What platform/programming language are you using?

    Comment

    • ghostrider
      New Member
      • Jan 2007
      • 34

      #3
      I'm using MS SQL 2005 Express. I'm trying to write a INSERT statement pulling data from my online school database and I'm not sure how to do it.

      Comment

      • srinit
        New Member
        • Jun 2007
        • 43

        #4
        Originally posted by ghostrider
        Okay I'm totally new to SQL, I need to write a program that has 2 tables, can any one help me get started?
        Hi,
        can you tell me clearly your requirements.re ally you want help for creating tables

        Comment

        • Infide
          New Member
          • Jul 2007
          • 28

          #5
          Originally posted by ghostrider
          I'm using MS SQL 2005 Express. I'm trying to write a INSERT statement pulling data from my online school database and I'm not sure how to do it.
          If I understand correctly, you are trying to insert data from one table into another.

          If these tables exist on different platforms you will need to write an application that does this.

          I will assume both tables are in the same database.

          INSERT INTO Table1(Column1, Column2)
          SELECT Column1,Column2
          FROM Table2

          Comment

          • ghostrider
            New Member
            • Jan 2007
            • 34

            #6
            Thanks this is what I was looking for. Thanks again!!!!

            Comment

            Working...