Results 1 to 2 of 2

Thread: Append tables

  1. Jul 27th, 2000, 05:36 AM #1
    frank ashley
    frank ashley is offline

    Thread Starter
    Lively Member
    Join Date
    May 2000
    Location
    London
    Posts
    99
    How do I append one table to another.

    I assume I'll have to use insert but I'm stuck from there.



    VB6 Enterprise sp5, SQL Server2000
    Reply With Quote Reply With Quote
  2. Jul 27th, 2000, 11:29 AM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    Insert..Select

    Insert table1
    select * from table2

    will move the contents of table 2 into table1. The tables need to posses compatible data types and structures
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width