Guest User

Untitled

a guest
Nov 16th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. for (var i=0;i<7000;i++){
  2. var registro1;
  3. var regisro2;
  4. var registro3;
  5. "EXEC test '"&registro1&"','"&registro2&"','"&registro3&"'";
  6.  
  7. }
  8.  
  9. CREATE PROCEDURE Clasificaciones(
  10. @registro1 varchar(7),
  11. @registro2 varchar(18),
  12. @registro3 varchar(2),
  13. )
  14. AS
  15. BEGIN
  16. SET NOCOUNT ON
  17.  
  18. MERGE tabla as TARGET
  19. USING(SELECT @registro1, @registro2, @registro3) AS SOURCE(registro1, registro2, registro3)
  20. ON (TARGET.registro1 = SOURCE.registro1 AND TARGET.registro2 = SOURCE.registro2)
  21. WHEN MATCHED THEN
  22. UPDATE SET regitro3 = SOURCE.registro3,
  23.  
  24. WHEN NOT MATCHED THEN
  25. INSERT (registro1,registro2,registro3)
  26. VALUES (SOURCE.regisro1, SOURCE.registro2, SOURCE.registro3);
  27. END
Add Comment
Please, Sign In to add comment