摘要: 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 阅读全文
posted @ 2012-08-28 11:43 tinaleft 阅读(138) 评论(0) 推荐(0) 编辑