How to copy data from one column to other column

Question

Hi all... I want to copy data from one column to another column of other table..so how i should i do that.. i did following thing

Update tblindiantime Set CountryName =(Select contacts.BusinessCountry From contacts) 

but its not working..

i want to copy "BusinessCountry" column of contact table to "CountryName" column of tblindiantime...

Answer 1

In SQL Server 2008 you can use a multi-table update as follows:

UPDATE tblindiantime 
SET tblindiantime.CountryName = contacts.BusinessCountry
FROM tblindiantime 
JOIN contacts
ON -- join condition here

You need a join condition to specify which row should be updated.

If the target table is currently empty then you should use an INSERT instead:

INSERT INTO tblindiantime (CountryName)
SELECT BusinessCountry FROM contacts

Answer 2

Hope you have key field is two tables.

 Update tblindiantime t
   Set CountryName = (Select contacts.BusinessCountry 
                     From contacts c WHERE c.Key = t.Key 
                     )