create table Satis ( UrunAdi varchar(20), BirimFiyati decimal(6,2), Adet int, Tutar as (BirimFiyati * Adet) )
insert into Satis values('Urun1',10.2,23) insert into Satis values('Urun1',1,10) select * from Satis ornek2: create table Kisi ( KisiId int, Ad varchar(50), Soyad varchar(50), AdSoyad as Ad+Space(1)+Soyad ) insert into Kisi values(1,'Sabri','Kunt') insert into Kisi values(1,'Ali','Demir') insert into Kisi values(1,'Ahmet','Tanryverdi') insert into Kisi values(1,'Seher','Kunt') select * from Kisi
