www.webdeveloper.com
Results 1 to 2 of 2

Thread: Copy sepecific data between tables in the same database

  1. #1
    Join Date
    Oct 2007
    Posts
    113

    Copy sepecific data between tables in the same database

    I have a two table lets say a and b. And from table b i want to copy only values of field1,field2 and field3 to table a's fieldx,fieldy and fieldz. Both tables have more than 3 fields. How i can do this

  2. #2
    Join Date
    May 2003
    Location
    Milwaukee
    Posts
    342
    try this (this worked in SQL Server 2005):

    insert into a (fieldx,fieldy,fieldz) select field1, field2, field3 from b

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles