select * from STKPROFITESTIMATEDETAIL where brokerid = 1
select OBJID, stkcode,brokerid,estimateyear,tbeps from STKPROFITESTIMATEDETAIL where brokerid = 1
000002、000060、000063
update STKPROFITESTIMATEDETAIL SET stkcode = '000002' WHERE stkcode = 002165
select * from STKPROFITESTIMATEDETAIL where brokerid = 1
select OBJID, stkcode,brokerid,estimateyear,tbeps from STKPROFITESTIMATEDETAIL where brokerid = 1
000002、000060、000063
select OBJID, stkcode,brokerid,estimateyear,tbeps from STKPROFITESTIMATEDETAIL WHERE stkcode = 002165 and brokerid = 1
update STKPROFITESTIMATEDETAIL SET stkcode = '000002' WHERE stkcode = 002165 and brokerid = 1