Ms SQL updates the value in Table B for a column in table

 

Ms SQL updates the value in Table B for a column in table

Select * <br/> from DBO. nt_areapin <br/> go <br/> select * <br/> from DBO. nt_dict_area </P> <p> Update nt_areapin <br/> set allnamepin = 'pengshanghai' <br/> from nt_areapin <br/> where areaid = '2016' <br/> go <br/> Update nt_dict_area <br/> set briefnamepin = nt_areapin.briefnamepin, allnamepin = nt_areapin.allnamepin <br/> from nt_dict_area, nt_areapin <br/> where nt_dict_area.name = nt_areapin.name; <br/> 

This article from urban homes, reproduced please indicate the source: http://www.edongguan.com/blog/b178.aspx