Compléter Views y procedure en sql serverVersion en ligne Creacion de views y procedures en sql server par Dulce G 1 order in upper from create as drop view view_listar_herramientas select ( herramienta ) as herramienta from herramientas ; 2 select update procedure set delete from values insert where create sp_actualizar @pais varchar ( 50 ) , @id int as begin paises pais = @pais idpais = @id ; end g o 3 WHERE view as VALUES SET INTO go begin end create procedure sp_insertar @herramienta varchar ( 50 ) , @stock int , @precio_unitario int begin insert paises ( herramienta , stock , precio_unitario ) ( @herramienta , @stock , @precio_unitario ) ; g o 4 sum select by avg delete for desc create drop set procedure sp_listar as begin ( precio_unitario ) as precio from herramientas order herramienta ; end g o 5 delete from sum max set min insert update view select create view_valor_maximo as ( precio_unitario ) as precio herramientas ;
Créer jeu