New Activity
New Activity
All the activities
Play Fill in the Blanks Game
g procedure drop begin where end view as
create ____________________ sp_eliminar @id int
____________________
____________________
delete from pais ____________________ idpais = @id ;
____________________
____________________
from drop in upper create order as
____________________ view view_listar_herramientas ____________________
select ____________________ ( herramienta ) as herramienta from herramientas ;
where select from delete values set update procedure insert
create ____________________ sp_actualizar @pais varchar ( 50 ) , @id int
as
begin
____________________ paises ____________________ pais = @pais ____________________ idpais = @id ;
end
g o
as VALUES end view begin go INTO 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
desc create for sum drop avg by delete set select
____________________ procedure sp_listar
as
begin
____________________ ____________________ ( precio_unitario ) as precio from herramientas order ____________________ herramienta ____________________ ;
end
g o
update min select delete from set view max sum insert
create ____________________ view_valor_maximo as
____________________ ____________________ ( precio_unitario ) as precio ____________________ herramientas ;