1-) MSSQL RMOS - boş veya null ise sıfır at

-- BOŞ VEYA NULL İSE SIFIR ATAR

declare @deger nvarchar(50)=''

declare @deger1 nvarchar(50)=NULL

declare @deger2 nvarchar(50)='123'

Select ISNULL(NULLIF(@deger,''),0)

Select ISNULL(NULLIF(@deger1,''),0)

Select ISNULL(NULLIF(@deger2,''),0)

--YAZILACAK KOD

Select ISNULL(NULLIF(@deger,''),0)

2024-03-08 ->

SELECT ISNULL(NULLIF(satis, ''), 0) AS satis FROM kur;