摘要:
declare @t table(CountryRegionCode nvarchar(3))insert into @t(CountryRegionCode) (select CountryRegionCode from person.CountryRegion where Name like "C%")select * from person.StateProvince where CountryRegionCode in (select * from @t)updatetestsettest.name=ta.namefrom@mytabeastawheretest.i 阅读全文