Notes

sequence olusturma
create sequence seq_ornek
as integer
start with 1
increment by 2
min value
max value
cache
cycle




sequence ile bi tabloya veri ekmelek
insert into t_bolgeler(bolge_no,bolge_adi)
valves(next valve for seq_ornek,`karadeniz bolgesi`)





sequence kullanilarak tablo olusturma


create table t_bolgeler2
id int not null constrations sequencest default next falve for seq_ornek
sehir varchar(100) not null






procedure function sequence 3 unden biri cagirma

exec ismi neyse


inser triggerli soru
update
delete


1nf
2nf
3nf
4nf
5nf


snonymous bir tablo yada view herhangi birinin yeni ismi

view
function bunlarda olsuturulur
table
procedure

veri temeli

varlik
iliski
nitelik






triggers olusturma

CREATE TRIGGER TR_BOLGELER
ON T_BOLGELER
AFTER INSERT
AS
BEGIN
SELECT `YENI KAYIT EKLENDI`
END


CREATE SYNONYM S_BOLGELER FOR T_BOLGELER





PROCEDURE OLUSTURMA

CREATE PROCEDURE P3_BOLGE_NO_YAZDIR
AS
BEGIN
DECLARE @BOLGEADI varchar(100)
DECLARE @bolgeNo INT
DECLARE @SQL varchar(max)

declare curbolgeler cursor fast forward for

select bolge_adi,bolge_no
from t_bolgeler
order by bolge_no
open cur bolgeler










create function f2_ilceler top(il_kodu varchar(20)
return int
as
begin

declare @mahsayisi int

select @mahsayisi=sum(c.mah_sayisi)
from t_ilceler c
where c.ilkododu=ti_kodu

if(@mah sayisi is null)
set(@mah sayisi=0)

return @mah sayisi
end




view olusturma

create view safasf as
select