API tools faq
paste
Advertisement
Diego1764

TABLA DEPARTAMENTO [SSMS]

Diego1764
Jun 16th, 2025
370
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.89 KB | None | 0 0
raw download clone embed print report
  1. -- TABLA DEPARTAMENTO
  2. CREATE PROCEDURE inserta_departamento
  3.     @codi_depa int,
  4.     @nombre nvarchar(30)
  5. AS
  6. BEGIN
  7.     INSERT INTO DEPARTAMENTO (codi_depa, nombre)
  8.     VALUES (@codi_depa, @nombre)
  9. END
  10. -- *******************************************************
  11. CREATE PROCEDURE actualiza_departamento
  12.     @codi_depa int,
  13.     @nombre nvarchar(30)
  14. AS
  15. BEGIN
  16.     UPDATE DEPARTAMENTO
  17.     SET nombre = @nombre
  18.     WHERE codi_depa = @codi_depa
  19. END
  20. -- *******************************************************
  21. CREATE PROCEDURE elimina_departamento
  22.     @codi_depa int
  23. AS
  24. BEGIN
  25.     DELETE FROM DEPARTAMENTO
  26.     WHERE codi_depa = @codi_depa
  27. END
  28. -- *******************************************************
  29. CREATE PROCEDURE consulta_departamento
  30.     @codi_depa int,
  31.     @nombre nvarchar(30) OUTPUT
  32. AS
  33. BEGIN
  34.     SELECT @nombre = nombre
  35.     FROM DEPARTAMENTO
  36.     WHERE codi_depa = @codi_depa
  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!