Msql(Ekle,Güncelle,Sil)(EbubekirBastama)

Create

database Ebubekir

use

Ebubekir

Create

table Dersler

(

id

intprimarykeyidentity(1,1),

arapca

nvarchar(max),

branice

nvarchar(max),

Yazili1

float,

Yazili2

float,

Yazili3

float,

Sozlu

float

)

Alter

table dersler

Alter

Column arapca int

insert

into Dersler(arapca,branice,Yazili1,Yazili2,Yazili3,Sozlu)values('25','50','60','80','90','100')

select

*from Dersler

update

Dersler set arapca ='60'

delete

from Dersler where arapca ='60'