Post reply

SQL Query For Insert

  • August 31, 2010 at 12:19 am

    #239699

    Hi,

    Pls can anyone tell , How to insert data into different table using single SQL Query

  • August 31, 2010 at 12:58 am

    #1214059

    How do you mean into a different table?

    Say you want to insert data from TableA into TableB you could do the following:

    insert into tableb (Col1, Col2, Col3)

    select AnotherCol1, AnotherCol2, AnotherCol3

    go

    Or..have I mis-understood the question?

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

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