UPDATE dbo.PL_TRADEDETAIL SET AMT_APP='11000000',PRICE=11000000 WHERE TRADE_ID='PLT000000071387' INSERT INTO dbo.PL_ROLE_DATA_CONFIG ( ROLE_TYPE, BRANCH_ID, DEP_ID ) SELECT 'TRADE_USER_VIEW',TLNANME,'GOO000001063657' FROM dbo.TL_USER WHERE SECUR_CODE='DEP000000000036'