Evra70

aaa

Dec 9th, 2021
948
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. BEGIN;
  2. UPDATE m_gen_tax_number
  3. SET invoice_id = -99,
  4. invoice_doc_type_id = -99,
  5. invoice_doc_no = '',
  6. invoice_doc_date = '',
  7. version = 0,
  8. update_user_id = -3,
  9. update_datetime = to_char(NOW(), 'YYYYMMDDHH24MIss')
  10. WHERE  tenant_id = 10
  11. AND tax_no = '007-21.40684275';
  12.  
  13. SELECT * FROM m_gen_tax_number WHERE  tenant_id = 10
  14. AND tax_no = '007-21.40684275';
  15. --rollback
RAW Paste Data