Clase 5 Continuación Ventas Mega: 

use BDVenasMega

go

--use BDVenasMega

--select * from TCategoria

--select * from  TProducto

--select * from TCliente

--select * from TVendedor

--select * from TBoleta

--select * from TDetalle

--go

if OBJECT_ID('splistarCategoria') is not null

drop proc splistarCategoria

go

create  proc  splistarCategoria

as

begin

select * from TCategoria

end

go

execute splistarCategoria

go

--

if OBJECT_ID('splistarProducto') is not null

drop proc splistarProducto

go

create  proc  splistarProducto

as

begin

select * from TProducto

end

go

execute splistarProducto

go

---

if OBJECT_ID('splistarCliente') is not null

drop proc splistarCliente

go

create  proc  splistarCliente

as

begin

select * from TCliente

end

go

execute splistarCliente

go

if OBJECT_ID('splistarVendedor') is not null

drop proc splistarVendedor

go

create  proc  splistarVendedor

as

begin

select * from TVendedor

end

go

execute splistarVendedor

go

--

if OBJECT_ID('splistarBoleta') is not null

drop proc splistarBoleta

go

create  proc  splistarBoleta

as

begin

select * from TBoleta

end

go

execute splistarBoleta

go

---

if OBJECT_ID('splistarDetalle') is not null

drop proc splistarDetalle

go

create  proc  splistarDetalle

as

begin

select * from TDetalle

end

go

execute splistarDetalle

go