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