Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. IF EXISTS(SELECT * FROM component_psar WHERE tbl_id = '2' AND row_nr = '1')
  2. THEN
  3. UPDATE component_psar SET col_1 = '1', col_2 = '1', col_3 = '1', col_4 = '1', col_5 = '1', col_6 = '1', unit = '1', add_info = '1', fsar_lock = '1' WHERE tbl_id = '2' AND row_nr = '1'
  4. ELSE
  5. INSERT INTO component_psar (tbl_id, row_nr, col_1, col_2, col_3, col_4, col_5, col_6, unit, add_info, fsar_lock) VALUES('2', '1', '1', '1', '1', '1', '1', '1', '1', '1', 'N')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement