diamond diamond

diamond diamond

  • NA
  • 133
  • 55.7k

how to insert value of column of a table to another?

Sep 2 2013 4:08 AM
Hi,
I have 2 tables which are in diffrent database in sql server 2008.
I want if the condition below was ok, the info column is put in other column of table.

INSERT INTO [p2p].[dbo].[Utorrent] (info )
SELECT  info
FROM    [test123].[dbo].[123]
WHERE   ([test123].[dbo].[123].Source = [p2p].[dbo].[Utorrent].daddr AND Destination =[p2p].[dbo].[Utorrent].saddr And Info LIKE 'no such name%');


please help me


Answers (1)