Devart Forums

Code: Select all

CREATE TABLE kurlar(
	tarih date NOT NULL,
	kur nvarchar(10) NOT NULL,
	da float NULL,
	ds float NULL,
	ea float NULL,
	es float NULL,
	ckusd float NULL,
	ckdiger float NULL,
	serbest float NULL,
 CONSTRAINT [PK_kurlar] PRIMARY KEY CLUSTERED 
(
	tarih ASC,
	kur ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

Code: Select all

select tarih, kur as "Döviz Cinsi", da as "Döviz Alış", ds as "Döviz Satış", ea as "Efektif Alış", es as "Efektif Satış", Serbest as "Serbest Piyasa"
from kurlar 
where tarih = :tarih