Advertisement
anne-hasan

Untitled

Mar 21st, 2022
27
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. INSERT INTO [dbo].[pillar_tr] ([project_trx_id], [type_of_pillars_id], [is_main_pillar], [is_delete], [create_date], [modify_date], [user_id_create], [user_id_modify])
  2. VALUES ('4347', '1650', '1', '', getdate(), NULL, '1', NULL);
  3.  
  4. UPDATE [dbo].[pillar_tr] SET [is_main_pillar] = '1' WHERE [pillar_tr_id] LIKE '1286';
  5.  
  6. UPDATE [dbo].[project_tr] SET [propose_total_funding] = '93399.9' WHERE [project_tr_id] LIKE '1185';
  7.  
  8. UPDATE [dbo].[project_tr] SET [propose_total_funding] = '33524.62' WHERE [project_tr_id] LIKE '4396';
  9. UPDATE [dbo].[pillar_tr] SET [type_of_pillars_id] = '1650' WHERE [pillar_tr_id] LIKE '5151';
  10.  
  11.  
  12. UPDATE [dbo].[project_tr] SET [propose_total_funding] = '2083946.54' WHERE [project_tr_id] LIKE '4374';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement