Fill in the Blanks Views y procedure en sql serverOnline version Creacion de views y procedures en sql server by Dulce G 1 upper order create as drop from in view view_listar_herramientas select ( herramienta ) as herramienta from herramientas ; 2 procedure select values where insert set from update delete create sp_actualizar @pais varchar ( 50 ) , @id int as begin paises pais = @pais idpais = @id ; end g o 3 INTO begin VALUES end as view go SET WHERE 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 drop select desc set delete create for avg sum by procedure sp_listar as begin ( precio_unitario ) as precio from herramientas order herramienta ; end g o 5 insert set sum max from update delete view min select create view_valor_maximo as ( precio_unitario ) as precio herramientas ;
New game