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