Post reply

small issue

  • February 25, 2008 at 11:51 am

    #184241

    i had a table 'NY' with 4 columns

    col1 col2 col3 col4

    now i have other table 'ABC' with 2 columns

    col1 col2

    i jus want to move or copy one of the columns from abc table to ny table ...

    plz let me know urgent ,....i have added the new column in ny table and i coudltn know what to do

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

  • February 25, 2008 at 12:58 pm

    #781719

    Look up INSERT and UPDATE in BOL. There are many ways to code this. The one you want may depend on requirements you did not mention.

    Simplest thing would be insert into xx select a,b from yy

  • February 25, 2008 at 7:00 pm

    #781831

    Hi,

    Simply you can use INSERT INTO

    I am curiuos to know about why you want to do this?

    Thanks -- Vj

    http://dotnetvj.blogspot.com

    Thanks -- Vijaya Kadiyala
    www.dotnetvj.com
    SQL Server Articles For Beginers


  • February 25, 2008 at 7:20 pm

    #781834

    actually i need to do some transformations to a column and insert that i coudlnt do that so i did some transformations separately i inserted into new table so i jus want to move that into other column now ....anyway thkz for ur reply..

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

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

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