Kategori arşivi: SQL

SQL de CASE — WHEN kullanımı

Yayın tarihi
Cevapla

Belirli koşullara göre bir sütunda yer almasını istediğimiz değeri getirmek.

SELECT IASPURINF.[DOCUMENT], IASPURINF.COMPANY, IASPURINF.PLANT, IASPURINF.MATERIAL, IASPURINF.VENDOR, IASPURINF.BUSAREA, IASPURINF.VALIDFROM,
IASPURINF.VALIDUNTIL, IASPURINF.PURDEPT, IASPURINF.NET, IASPURINF.PUNIT, IASPURINF.CURRENCY, IASPURINF.PURUNIT, IASPURINF.STEXT,
IASPURINF.DELIVERYDAY, IASPURINF.MINORDER, IASPURINF.VMATERIAL, IASCUSTOMER.NAME1
,V.EXCHRATESAL
,CASE WHEN IASPURINF.CURRENCY =’TL’ THEN IASPURINF.NET ELSE IASPURINF.NET * V.EXCHRATESAL END AS FTL
FROM IASCUSTOMER INNER JOIN
IASPURINF ON IASCUSTOMER.CLIENT = IASPURINF.CLIENT AND IASCUSTOMER.COMPANY = IASPURINF.COMPANY AND
IASCUSTOMER.CUSTOMER = IASPURINF.VENDOR AND IASCUSTOMER.BUSAREA = IASPURINF.BUSAREA LEFT OUTER JOIN
VW_IAS_KUR AS V ON IASPURINF.CURRENCY = V.CURRENCY
WHERE (IASPURINF.CLIENT = ’00′) AND (IASPURINF.COMPANY LIKE ’01′) AND (IASPURINF.PLANT LIKE ‘%’) AND (IASPURINF.VENDOR LIKE ‘%’) AND
(IASPURINF.MATERIAL LIKE ‘WU17X13′) AND (IASPURINF.BUSAREA LIKE ‘%’) AND (IASPURINF.[DOCUMENT] = 4) AND (IASPURINF.ITEMNUM = 1) AND
(IASCUSTOMER.ISCUSTORVEND >= 2) AND (IASPURINF.STEXT LIKE ‘%’) AND (IASCUSTOMER.NAME1 LIKE ‘%’) AND (IASPURINF.PURDEPT LIKE ‘%’) AND
(IASPURINF.VALIDFROM <= GETDATE()) AND (IASPURINF.VALIDUNTIL >= GETDATE()) AND (IASPURINF.ISDELETE = 0)
ORDER BY IASPURINF.COMPANY, IASPURINF.PLANT, IASPURINF.MATERIAL, IASPURINF.VENDOR, IASPURINF.BUSAREA

SQL linked server access 2007

Yayın tarihi
Cevapla

USE [master]
GO
EXEC master.dbo.sp_addlinkedserver @server = N’ACCESS’, @srvproduct=N’access’, @provider=N’Microsoft.ACE.OLEDB.12.0′, @datasrc=N’E:\DosyaAdi.accdb’
GO

USE [master]
GO
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N’ACCESS’, @locallogin = NULL , @useself = N’False’
GO

select * from ACCESS…TabloAdi

Sql sayısal fonsiyonlar

Yayın tarihi
Cevapla

Sayıları yuvarlama, mutlak değerini alma, kuvvet alma gibi sayısal fonsiyonlar….

SELECT 1.0/3.0 AS BOLME

, CEILING(1.0/3.0) AS YUKARIYUVARLA

, CEILING(2.09) AS YUKARIYUVARLA2
, ABS(-1) AS MUTLAKDEGER

, FLOOR(2.09) AS ASAGIYUVARLA
,ROUND(1.4,0) AS BUCUKASAGI

, ROUND (1.6,0) AS BUCUKYUKARI

, SQRT(144) AS KOKAL

, RAND() AS RASTGELESAYI
,POWER(12,2) AS KUVVET;