甯歌闂涓庡垎鏋?/div>
鍏抽棴
鎬誨寘8.2.7棣栭〉鏄劇ず鈥滄暟鎹紓甯糕?/span>
濡傛灉鏄?.2.2浠ヤ笅鐨勫鎴峰崌綰у埌8..2.7鏃訛紝璇鋒墽琛屽畬鎵鏈夊崌綰ц剼鏈悗錛屾煡涓媋dmin鐢ㄦ埛錛屽搴旂殑sdpj004.pj00401鐨勫鹼紝灝嗚鏇挎崲鍒皊dbj201.bj20103瀛楁閲屻?/p>
1銆佹煡璇㈡柟娉?/span>
Select pj00401 From sdpj004,sdey003 Where pj00421=ey00301 And ey00313='Admin'
2銆佷慨姝ｆ柟娉?/span>
Update sdbj201 set bj20103='鏌ュ埌鐨刾j00401鍊?#39; where bj20101 in('A0000001','A0000002','A0000003')