Advertisement
Evra70

a

Dec 9th, 2021
1,220
0
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. WHERE  tenant_id = 10
  8. AND tax_no = '007-21.40684275';
  9.  
  10. select * from m_gen_tax_number WHERE  tenant_id = 10
  11. AND tax_no = '007-21.40684275';
  12.  
  13. --rollback
  14.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement