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
Posted Sep 2, 2013, 4:14 AM
http://msdn.microsoft.com/en-us/library/aa560998.aspx