Thread: tables

    #1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    20
    Rep Power
    0

    tables


    hi i m trying to dump data from table A to table B in different schema but same instance. now table A has column that has different data values then table B. for example
    TABLE A. identification_no varachar(5)
    TABLE B .reference_id varchar(15)
    can someone help me with the script here they are pretty big tables.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    68
    Rep Power
    12
    I think we spoke about this issue in http://forums.devshed.com/t92585/s.html.
    Maybe what was posted there looks too simplistic but that's the power of a fourth generation language like SQL: You specify only what has to be done without being concerned about the underlying details.

    Cheers,
    Dan

IMN logo majestic logo threadwatch logo seochat tools logo