Notes

/* CRUD Başlamadan önce tüm spleri temizle*/



/* CREATE */

use Kitaphane2018
go
create procedure spKatKay( @kayAd varchar(50)) as begin insert into Tbl_Kategori values(@kayAd) end
go
exec spKatKAy 'Yeni Kayıt Ekleme'
go

/* UPDATE */
create procedure spKatGunc( @katNo int, @katAd varchar(50)) as begin update Tbl_Kategori set Kat_Ad=@katAd where Kat_Id=@katNo end
go
exec spKatGunc 5,'Sercan'
go

/* DELETE */
create procedure spKatSil(@katNo int) as begin delete from Tbl_Kategori where Kat_Id=@katNo end
go
exec spKatSil 5
go

/* READ only one */
create procedure spKatSec (@katNo int) as begin select * from Tbl_Kategori where Kat_Id=@katNo end
go
exec spKatSec 2
go
/* READ all*/
create procedure spKatGetir as begin select * from Tbl_Kategori end
go
exec spKatGetir

/* --------------------ÖRNEKLER--------------------- */
/*KİTAP TABLOSU*/
/* CREATE */

create procedure spKitapKay(@kitapAd varchar(50), @KatNo int, @yazarno int,@yayinno int, @ozet varchar(50),@resim varchar(50),@fiyat int,@Basim date)
as begin insert into Tbl_Kitap values (@kitapAd, @KatNo , @yazarno,@yayinno,@ozet,@resim,@fiyat,@Basim) end
go
exec spKitapKay 'Fareler ve İnsanlar',1,2,1,'Güzel','Güzel',500,'05.05.2001'
go

/* UPDATE */
create procedure spKitapUpd(@kitapNo int, @kitapAd varchar(50)) as begin update Tbl_Kitap set Kitap_Ad=@kitapAd where Kitap_Id=@kitapNo end
go
exec spKitapUpd 2, 'Simyacı'
go

/* DELETE */
create procedure spKitapDel(@kitapNo int) as begin delete from Tbl_Kitap where Kitap_Id=@kitapNo end
go
exec spKitapDel 1
go
/* Read only one */
create procedure spKitapRoo(@kitapNo int) as begin select Kitap_Ad from Tbl_Kitap where Kitap_Id=@kitapNo end
go
exec spKitapRoo 3
go
/*Read all*/
create procedure spKitapRa as begin select * from Tbl_Kitap end
go
exec spKitapRa

/* SATIS TABLOSU */
create procedure spSatisKAy( @uyeno int, @kitapno int,@adet int) as begin insert into Tbl_Satis values (@uyeno,@kitapno,@adet) end
go
exec spSatisKay 1,1,1
go

create procedure spSatisUpd(@satisid int,@uyeno int, @kitapno int, @adet int) as begin update Tbl_Satis set Uye_No=@uyeno, Kitap_No=@kitapno, Adet=@adet where Satis_Id=@satisid end
go
exec spSatisUpd 1,1,2,3
go

create procedure spSatisDel(@satisid int) as begin delete from Tbl_Satis where Satis_Id=@satisid end
go
exec spSatisDel 1
go

create procedure spSatisRoo(@satisid int) as begin select * from Tbl_Satis where Satis_Id=@satisid end
go
exec spSatisRoo 2
go

create procedure spSatisRa as begin select * from Tbl_Satis end
go
exec spSatisRa
go
/* UYE TABLOSU */
create procedure spUyeKay(@sicilno int,@uyeAd varchar(50), @uyesoyad varchar(50),@uyeAdres varchar(50),@uyetel varchar(50),@uyemail varchar(50))
as begin insert into Tbl_Uye values(@sicilno,@uyeAd,@uyesoyad,@uyeAdres,@uyetel,@uyemail) end
go
exec spUyeKay 1,'Sercan','Çetin','MehterCeşme','535352560','[email protected]'
go

create procedure spUyeUpd(@uyeid int,@sicilno int,@uyeAd varchar(50), @uyesoyad varchar(50),@uyeAdres varchar(50),@uyetel varchar(50),@uyemail varchar(50))
as begin update Tbl_Uye set Uye_Ad=@uyeAd, Sicil_No=@sicilno,Uye_Soyad=@uyesoyad,Uye_Adres=@uyeAdres,Uye_Tel=@uyetel,Uye_Email=@uyemail where Uye_Id=@uyeid end
go
exec spUyeUpd 1,2,'Sercan','Çetin','Mehter','55555555','[email protected]'