API tools faq
paste
Advertisement
Diego1764

TABLA CARGO INTERNACIONAL [SSMS]

Diego1764
Jun 16th, 2025
335
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.00 KB | None | 0 0
raw download clone embed print report
  1. -- TABLA CARGO INTERNACIONAL
  2. CREATE PROCEDURE inserta_cargo_internacional
  3.     @codi_carg int,
  4.     @descripcion nvarchar(40)
  5. AS
  6. BEGIN
  7.     INSERT INTO CARGO_INTERNACIONAL (codi_carg, descripcion)
  8.     VALUES (@codi_carg, @descripcion)
  9. END
  10. -- *******************************************************
  11. CREATE PROCEDURE actualiza_cargo_internacional
  12.     @codi_carg int,
  13.     @descripcion nvarchar(40)
  14. AS
  15. BEGIN
  16.     UPDATE CARGO_INTERNACIONAL
  17.     SET descripcion = @descripcion
  18.     WHERE codi_carg = @codi_carg
  19. END
  20. -- *******************************************************
  21. CREATE PROCEDURE elimina_cargo_internacional
  22.     @codi_carg int
  23. AS
  24. BEGIN
  25.     DELETE FROM CARGO_INTERNACIONAL
  26.     WHERE codi_carg = @codi_carg
  27. END
  28. -- *******************************************************
  29. CREATE PROCEDURE consulta_cargo_internacional
  30.     @codi_carg int,
  31.     @descripcion nvarchar(40) OUTPUT
  32. AS
  33. BEGIN
  34.     SELECT @descripcion = descripcion
  35.     FROM CARGO_INTERNACIONAL
  36.     WHERE codi_carg = @codi_carg
  37. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!