Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- for (var i=0;i<7000;i++){
- var registro1;
- var regisro2;
- var registro3;
- "EXEC test '"®istro1&"','"®istro2&"','"®istro3&"'";
- }
- CREATE PROCEDURE Clasificaciones(
- @registro1 varchar(7),
- @registro2 varchar(18),
- @registro3 varchar(2),
- )
- AS
- BEGIN
- SET NOCOUNT ON
- MERGE tabla as TARGET
- USING(SELECT @registro1, @registro2, @registro3) AS SOURCE(registro1, registro2, registro3)
- ON (TARGET.registro1 = SOURCE.registro1 AND TARGET.registro2 = SOURCE.registro2)
- WHEN MATCHED THEN
- UPDATE SET regitro3 = SOURCE.registro3,
- WHEN NOT MATCHED THEN
- INSERT (registro1,registro2,registro3)
- VALUES (SOURCE.regisro1, SOURCE.registro2, SOURCE.registro3);
- END
Add Comment
Please, Sign In to add comment