store procedures
2 views
Skip to first unread message
Saul Cruz
Oct 25, 2010, 1:41:21 PM10/25/10
to cima...@googlegroups.com
CREATE PROCEDURE traerLineas
as begin
select * from dbo.Lineas
end
-------
create procedure traerRutasLineas
@idLineas int
as
begin
select idRutas,Nombre_ruta from Rutas where lineas_idLineas=@idLinea
end
-----------
create procedure traerInforRutas
@idRutas int
as begin
select * Rutas where idRutas = @idRutas
end
----------
create procedure traerRutasCalles
@idCalle int
as begin
select idRutas, Nombre_ruta from Rutas_Calles,Rutas where Calles_idCalles = @idCalle and Rutas_idRUtas = idRutas
end
--------------
create procedure traerRutasLugares
@idLugares int
as begin
select idRutas, Nombre_ruta from Rutas_Lugares,Rutas where Lugares_idLugares = @idLugares and Rutas_idRUtas = idRutas
end
------
create procedure traerCapas
@idCapa int
as begin
select URL from Capas where idCapas = @idCapa
end
---------
create procedure traerLugares
as begin
select * from Lugares
end
-----------
create procedure traerCalles
as begin
select * form Calles
end
----------
create procedure agregarRuta
@idCapa int,
@idLinea int,
@Nom_Ruta varchar(45),
@Tarifa int,
@Frecuencia varchar(45)
as begin
INSERT INTO Rutas VALUES (@idCapa,@idLinea,@Nom_Ruta, @Tarifa, @Frecuencia)
end
create procedure modificarRuta
@idRuta
@idCapa int,
@idLinea int,
@Nom_Ruta varchar(45),
@Tarifa int,
@Frecuencia varchar(45)
as begin
Update Rutas set Capas_idCapas = @idCapa, Lineas_idLineas = @idLinea, Nombre_Ruta = @Nom_Ruta,Tarifa = @Tarifa, Frecuencia = @Frecuencia)
end
create procedure eliminarRuta
@idRuta
as begin
DELETE FROM Rutas WHERE idRuta = @idRuta ;
end
Reply all
Reply to author
Forward
0 new messages