مطالب مرتبط با «sql server 2012 feature pack» در back soft | نویسنده: استخدام کار
SQL server 2012 conditional update on table 1 from a temp table
Vote count: 0 I have 2 tables 1 [dbo].[t_Olympic_Country] where i have all the county list but population and GDP is empty. Now i have second table which has most of the countries with population and GDP data but its it has not same number of data. I would like to enter value of GDP and population from 2nd temp table [dbo].[temptable1] to first [dbo].[t_Olympic_Country] in case the cuntry name matches with [dbo].[t_Olympic_Country]. I mean a conditional bulk update for [dbo].[t_Olympic_Country]. Can anybody help me? i tried following which gives error : INSERT INTO [dbo].[t_Olympic_Country]( [GDP] ) SELECT temp.[GDP] FROM [dbo].[temptable1] temp WHERE (temp.[Country_Name] IN (SELECT tl.[Coun...
ادامه مطلب
