Post reply

HOW TO INSERT RECORD FROM A TABLE TO ANOTHER.

  • June 18, 2008 at 2:22 am

    #208471

    I try to insert all record from a table in a database

    to a equal table in another database

    Insert into [DB1].TABLE1

    (FLD1,FLD2,FLD3)

    (

    select

    FLD1,FLD2,FLD3

    from [DB2].TABLE2

    )

    TABLE1 and TABLE2 are equal !!!!

    someone can help me ???

    thank you in advance

  • June 18, 2008 at 2:28 am

    #830257

    Alberto.Omini (6/18/2008)

    I try to insert all record from a table in a database

    to a equal table in another database

    Insert into [DB1].TABLE1

    (FLD1,FLD2,FLD3)

    (

    select

    FLD1,FLD2,FLD3

    from [DB2].TABLE2

    )

    TABLE1 and TABLE2 are equal !!!!

    someone can help me ???

    thank you in advance

    INSERT INTO dbo.table1

    SELECT fld1,

    fld2,

    fld3

    FROM db2.dbo.table1

    Regards,

    ANdras

    Andras Belokosztolszki, MCPD, PhD
    GoldenGate Software

  • June 18, 2008 at 2:40 am

    #830259

    thank you very much !!!!

    i solve.......

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply