1.0 UPDATE NS SU DUNG DU KIEN 89 TR.txt
| 1 |
UPDATE PL_TRADEDETAIL SET AMT_ETM =89000000 WHERE TRADE_ID ='PLT000000278913' |
|---|---|
| 2 |
DECLARE @REQ_ID VARCHAR(15) |
| 3 |
SET @REQ_ID =(SELECT REQ_PAY_ID FROM TR_REQ_PAYMENT WHERE REQ_PAY_CODE ='082021/000315') |
| 4 |
SELECT * FROM TR_REQ_PAY_METHOD WHERE REQ_PAY_ID=@REQ_ID |
| 5 |
UPDATE TR_REQ_PAY_METHOD SET ACC_NO ='0017041044843', ACC_NAME='Công ty TNHH Phần mềm Hoàn Cầu', ISSUED_BY ='BVB-CN Tây Sài Gòn' WHERE REQ_PAY_ID =@REQ_ID |
| 6 |
SELECT * FROM CM_SUPPLIER |
| 7 |
UPDATE CM_SUPPLIER SET MAKER_ID ='tuyenlt' WHERE SUP_ID ='CMS000000251971' |