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