Database Health Check — Veritabanı Sağlık Kontrolleri

SELECT COUNT(*) FROM (SELECT I.Id, I.IslemKodu, I.IslemTuru, I.IslemTipi, I.HesapId, I.Tarih
FROM Cari.Islemler I
WHERE I.IsDeleted = 0
  AND I.IslemTipi NOT IN (1, 11, 12)
  AND (
        (I.IslemKodu IN (1,2,9,4,5,6) AND ((I.BakiyeId > 0 AND I.Miktar <> 0) OR ISNULL(I.Tutar,0) <> 0))
     OR (I.IslemKodu IN (0,14))
     OR (I.IslemKodu NOT IN (0,1,2,4,5,6,9,14) AND ISNULL(I.Tutar,0) <> 0)
      )
  AND NOT EXISTS (SELECT 1 FROM Cari.BakiyeIslem B WHERE B.IslemId = I.Id)) x

SELECT COUNT(*) FROM (SELECT 'BakiyeIslem' AS Kaynak, B.IslemId FROM Cari.BakiyeIslem B
JOIN Cari.Islemler I ON I.Id = B.IslemId
WHERE I.IsDeleted = 1 OR I.IslemTipi IN (11,12)
UNION ALL
SELECT 'StokHaraketleri', H.IslemId FROM Stok.StokHaraketleri H
JOIN Cari.Islemler I ON I.Id = H.IslemId AND H.Bolum = 0
WHERE I.IsDeleted = 1 OR I.IslemTipi IN (11,12)) x

SELECT COUNT(*) FROM (SELECT B.IslemId, I.IslemKodu, B.BirimId, B.Bakiye
FROM Cari.BakiyeIslem B JOIN Cari.Islemler I ON I.Id = B.IslemId
WHERE I.IslemTipi = 1 AND I.IslemKodu NOT IN (0,14)) x

SELECT COUNT(*) FROM (SELECT I.Id, I.HesapId, I.SubeId, I.KasaId
FROM Cari.Islemler I
WHERE I.IsDeleted = 0 AND (
      I.HesapId = 0 OR NOT EXISTS (SELECT 1 FROM Cari.Hesaplar H WHERE H.Id = I.HesapId)
   OR I.SubeId = 0  OR NOT EXISTS (SELECT 1 FROM Sistem.Subeler S WHERE S.Id = I.SubeId)
   OR I.KasaId = 0  OR NOT EXISTS (SELECT 1 FROM Sistem.Kasalar K WHERE K.Id = I.KasaId))) x

SELECT COUNT(*) FROM (SELECT Id, IslemKodu, IslemTuru, Miktar, Adet, Tutar
FROM Cari.Islemler
WHERE IsDeleted = 0 AND (Miktar < 0 OR Adet < 0 OR Tutar < 0)) x

SELECT COUNT(*) FROM (SELECT D.IslemId, D.ETTN, D.Durum FROM Cari.IslemDetaylari D JOIN Cari.Islemler I ON I.Id = D.IslemId
WHERE I.IsDeleted = 1 AND (ISNULL(D.ETTN,'') = '' OR ISNULL(D.Durum,'') <> 'EIPTAL')) x

SELECT COUNT(*) FROM (SELECT 'BakiyeIslem' AS Tablo, COUNT(*) FROM Cari.BakiyeIslem WHERE Tarih IS NULL
UNION ALL SELECT 'StokHaraketleri', COUNT(*) FROM Stok.StokHaraketleri WHERE Tarih IS NULL
UNION ALL SELECT 'Islemler', COUNT(*) FROM Cari.Islemler WHERE Tarih IS NULL AND IsDeleted = 0) x

SELECT COUNT(*) FROM (SELECT FisNo, KasaId, COUNT(DISTINCT Tarih) AS GunSayisi, COUNT(DISTINCT HesapId) AS HesapSayisi
FROM Cari.Islemler WHERE IsDeleted = 0
GROUP BY FisNo, KasaId HAVING COUNT(DISTINCT Tarih) > 1 OR COUNT(DISTINCT HesapId) > 1) x

SELECT COUNT(*) FROM (SELECT 'VIRMAN' AS Tip, RefNo, COUNT(*) AS Adet FROM Cari.Islemler WHERE IsDeleted = 0 AND IslemKodu = 11 GROUP BY RefNo HAVING COUNT(*) <> 2
UNION ALL
SELECT 'PARITE', CONVERT(nvarchar(72), a.Id), 1 FROM Cari.Islemler a
WHERE a.IsDeleted = 0 AND a.IslemKodu = 3 AND a.VaryantId = -1
  AND NOT EXISTS (SELECT 1 FROM Cari.Islemler b WHERE b.VaryantId = a.Id AND b.IsDeleted = 0)) x

SELECT COUNT(*) FROM Cari.Islemler I JOIN Sistem.Subeler S ON S.Id = I.SubeId WHERE I.IsDeleted = 0 AND S.IsActive = 0 AND I.InsertDate > DATEADD(day,-30,GETDATE())

SELECT COUNT(*) FROM Cari.Islemler WHERE Tag IS NOT NULL AND TRY_CONVERT(int, Tag) IS NULL

SELECT COUNT(*) FROM Cari.Islemler WHERE HesapType IS NULL

SELECT COUNT(*) FROM Cari.IslemDetaylari D JOIN Cari.Islemler I ON I.Id = D.IslemId WHERE I.IsDeleted = 1 AND ISNULL(D.ETTN,'') = ''

SELECT CASE WHEN IDENT_CURRENT('Cari.Islemler') < (SELECT ISNULL(MAX(Id),0) FROM Cari.Islemler) THEN 1 ELSE 0 END

SELECT COUNT(*) FROM (SELECT I.Id, I.Tutar, B.Bakiye
FROM Cari.Islemler I JOIN Cari.BakiyeIslem B ON B.IslemId = I.Id AND B.BirimId = I.BirimId
WHERE I.IsDeleted = 0 AND I.IslemTipi NOT IN (1,11,12) AND I.IslemKodu NOT IN (0,14)
  AND ISNULL(I.Tutar,0) <> 0 AND ABS(ABS(B.Bakiye) - ABS(I.Tutar)) > 0.005) x

SELECT COUNT(*) FROM (SELECT I.Id, I.IslemKodu, I.IslemTuru, B.BirimId, B.Bakiye
FROM Cari.Islemler I JOIN Cari.BakiyeIslem B ON B.IslemId = I.Id AND B.BirimId = I.BirimId
WHERE I.IsDeleted = 0 AND I.IslemTipi NOT IN (1,10,11,12) AND I.IslemKodu NOT IN (0,14)
  AND ISNULL(I.Tutar,0) <> 0
  AND ((I.IslemTuru % 2 = 0 AND B.Bakiye > 0) OR (I.IslemTuru % 2 = 1 AND B.Bakiye < 0))) x

SELECT COUNT(*) FROM (SELECT B.BirimId, COUNT(*) AS Adet, SUM(B.Bakiye) AS Toplam
FROM Cari.BakiyeIslem B
WHERE B.BirimId IS NULL OR (B.BirimId <> -1 AND NOT EXISTS (SELECT 1 FROM Sistem.Birimler Br WHERE Br.Id = B.BirimId))
GROUP BY B.BirimId) x

CTE:WITH Beklenen AS (
  SELECT I.HesapId, I.BirimId,
         SUM(CASE WHEN I.IslemTuru % 2 = 0 THEN -ABS(I.Tutar) ELSE ABS(I.Tutar) END) AS Tutar
  FROM Cari.Islemler I
  WHERE I.IsDeleted = 0 AND I.IslemTipi NOT IN (1,10,11,12) AND I.IslemKodu NOT IN (0,14) AND ISNULL(I.Tutar,0) <> 0
  GROUP BY I.HesapId, I.BirimId),
Gercek AS (
  SELECT B.HesapId, B.BirimId, SUM(B.Bakiye) AS Bakiye
  FROM Cari.BakiyeIslem B JOIN Cari.Islemler I ON I.Id = B.IslemId AND B.BirimId = I.BirimId
  WHERE I.IslemKodu NOT IN (0,14) AND I.IslemTipi <> 10
  GROUP BY B.HesapId, B.BirimId)
SELECT @n = COUNT(*)
FROM Beklenen e FULL JOIN Gercek g ON g.HesapId = e.HesapId AND g.BirimId = e.BirimId
WHERE ABS(ISNULL(e.Tutar,0) - ISNULL(g.Bakiye,0)) > 0.01

SELECT COUNT(*) FROM (SELECT (SELECT COUNT(*) FROM Sistem.Subeler WHERE IsLimitControl = 1 AND IsDeleted = 0) AS LimitKontrolluSube,
       (SELECT COUNT(*) FROM Cari.BakiyeDun) AS BakiyeDunSatir,
       (SELECT MAX(Tarih) FROM Cari.BakiyeDun) AS SonTarih,
       DATEADD(day,-1,CONVERT(date,GETDATE())) AS Beklenen) x

SELECT COUNT(*) FROM (SELECT I.Id, I.IslemKodu, I.IslemTipi, I.KasaId
FROM Cari.Islemler I
WHERE I.IsDeleted = 0 AND I.IslemTipi NOT IN (11,12)
  AND (I.IslemKodu IN (0,1,2,8,9) OR (I.IslemKodu = 3 AND I.IslemTipi <> 4) OR I.IslemTipi = 1)
  AND NOT EXISTS (SELECT 1 FROM Stok.StokHaraketleri H WHERE H.IslemId = I.Id AND H.Bolum = 0)) x

SELECT COUNT(*) FROM (SELECT H.IslemId, H.StokTipi, H.IslemTuru, H.Miktar, H.Adet
FROM Stok.StokHaraketleri H JOIN Cari.Islemler I ON I.Id = H.IslemId AND H.Bolum = 0
WHERE NOT (I.IslemTipi = 1 AND H.StokTipi = 2 AND H.StokId = I.BirimId)    
  AND ((H.IslemTuru = 0 AND (H.Miktar < 0 OR H.Adet < 0)) OR (H.IslemTuru = 1 AND (H.Miktar > 0 OR H.Adet > 0)))) x

SELECT COUNT(*) FROM (SELECT I.Id, I.Miktar * I.AuMilyem AS HasHesap, H.Has AS StokHas, B.Bakiye AS BakiyeHas
FROM Cari.Islemler I
LEFT JOIN Stok.StokHaraketleri H ON H.IslemId = I.Id AND H.Bolum = 0 AND H.StokTipi = 1
LEFT JOIN Cari.BakiyeIslem B ON B.IslemId = I.Id AND B.BirimId = I.BakiyeId AND I.BakiyeId > 0
WHERE I.IsDeleted = 0 AND I.IslemKodu IN (1,2) AND I.IslemTipi NOT IN (1,11,12)
  AND ( (H.IslemId IS NOT NULL AND ABS(ABS(H.Has) - ABS(I.Miktar * I.AuMilyem)) > 0.0001)
     OR (B.IslemId IS NOT NULL AND ABS(ABS(B.Bakiye) - ABS(I.Miktar * I.AuMilyem)) > 0.0051) )) x

SELECT COUNT(*) FROM (SELECT T.Id, T.Status, T.IsDeleted, COUNT(H.IslemId) AS HareketSayisi
FROM Cari.Transferler T
LEFT JOIN Stok.StokHaraketleri H ON H.IslemId = T.Id AND H.Bolum = 2
GROUP BY T.Id, T.Status, T.IsDeleted
HAVING (T.Status = 1 AND T.IsDeleted = 0 AND COUNT(H.IslemId) <> 2)
    OR ((T.Status <> 1 OR T.IsDeleted = 1) AND COUNT(H.IslemId) > 0)) x

SELECT COUNT(*) FROM (SELECT StokId, SUM(Adet) AS Adet FROM Stok.StokHaraketleri WHERE StokTipi = 3 GROUP BY StokId HAVING SUM(Adet) NOT IN (0,1)) x

SELECT COUNT(*) FROM (SELECT IslemId, Bolum, StokId, Miktar, Milyem, Has FROM Stok.StokHaraketleri
WHERE StokTipi = 1 AND (Milyem > 1 OR (Milyem <> 0 AND ABS(Has - Miktar * Milyem) > 0.0001))) x

SELECT COUNT(*) FROM (SELECT 'HISTORY_YOK' AS Sorun, I.Id FROM Cari.Islemler I
WHERE NOT EXISTS (SELECT 1 FROM Cari.History H WHERE H.TransactionId = I.Id)
UNION ALL
SELECT 'ORPHAN_HISTORY', H.TransactionId FROM Cari.History H
WHERE NOT EXISTS (SELECT 1 FROM Cari.Islemler I WHERE I.Id = H.TransactionId)
  AND H.LogDate >= (SELECT MIN(InsertDate) FROM Cari.Islemler)) x

SELECT COUNT(*) FROM Sistem.SilAciklama S WHERE NOT EXISTS (SELECT 1 FROM Cari.Islemler I WHERE I.Id = S.TransID)

SELECT COUNT(*) FROM (SELECT a.Id AS Id1, b.Id AS Id2, a.HesapId, a.Tarih, a.IslemKodu, a.Kodu, a.Miktar, a.Tutar, a.InsertDate AS InsertDate1, b.InsertDate AS InsertDate2
FROM Cari.Islemler a
JOIN Cari.Islemler b ON b.Id > a.Id AND b.HesapId = a.HesapId AND b.Tarih = a.Tarih
  AND b.IslemKodu = a.IslemKodu AND b.IslemTuru = a.IslemTuru AND ISNULL(b.Kodu,'') = ISNULL(a.Kodu,'')
  AND b.Miktar = a.Miktar AND ISNULL(b.Tutar,0) = ISNULL(a.Tutar,0)
  AND ABS(DATEDIFF(second, a.InsertDate AS InsertDate1, b.InsertDate AS InsertDate2)) <= 60
WHERE a.IsDeleted = 0 AND b.IsDeleted = 0 AND a.IslemKodu <> 11) x

SELECT COUNT(*) FROM (SELECT ActivitySubeId FROM Sistem.Activity GROUP BY ActivitySubeId HAVING COUNT(*) > 1) x

SELECT COUNT(*) FROM (SELECT VergiNo, SubeId FROM Cari.Hesaplar WHERE IsDeleted = 0 AND ISNULL(VergiNo,'') <> '' GROUP BY VergiNo, SubeId HAVING COUNT(*) > 1) x

SELECT COUNT(*) FROM (SELECT SenderID FROM Cari.RSReferans GROUP BY SenderID HAVING COUNT(*) > 1) x

SELECT COUNT(*) FROM (SELECT Kodu, COUNT(*) FROM Sistem.Birimler WHERE IsDeleted = 0 GROUP BY Kodu HAVING COUNT(*) > 1) x

SELECT COUNT(*) FROM (SELECT Kodu FROM Sistem.Birimler WHERE IsDeleted = 0 GROUP BY Kodu HAVING COUNT(*) > 1) x

SELECT COUNT(*) FROM (SELECT 'SIFIR' AS Sorun, K.Id, K.BirimId, K.Tarih FROM Sistem.Kurlar K WHERE K.IsDeleted = 0 AND (ISNULL(K.Alis,0) <= 0 OR ISNULL(K.Satis,0) <= 0)
UNION ALL
SELECT 'MUKERRER', MIN(Id), BirimId, Tarih FROM Sistem.Kurlar WHERE IsDeleted = 0 GROUP BY BirimId, Tarih HAVING COUNT(*) > 1
UNION ALL
SELECT 'ILERI_TARIH', Id, BirimId, Tarih FROM Sistem.Kurlar WHERE IsDeleted = 0 AND Tarih > CONVERT(date, GETDATE())
UNION ALL
SELECT 'BUGUN_YOK', B.Id, B.Id, CONVERT(date, GETDATE()) FROM Sistem.Birimler B
WHERE B.IsDeleted = 0 AND B.IsComputed = 0
  AND NOT EXISTS (SELECT 1 FROM Sistem.Kurlar K WHERE K.BirimId = B.Id AND K.Tarih = CONVERT(date, GETDATE()) AND K.IsDeleted = 0)) x

SELECT COUNT(*) FROM (SELECT Id, Tarih, HasKur, GumKur, UsdKur, EurKur, BirimKur FROM Cari.Islemler
WHERE IsDeleted = 0 AND (ISNULL(HasKur,0) IN (0,1) OR ISNULL(UsdKur,0) IN (0,1) OR ISNULL(BirimKur,0) = 0)) x

SELECT COUNT(*) FROM Cari.Islemler WHERE IsDeleted = 0 AND (ISNULL(HasKur,0) = 0 OR ISNULL(IscilikBirimKur,0) = 0) AND IslemKodu = 0

SELECT COUNT(*) FROM Sistem.Kurlar WHERE BirimId = 1 AND ISNULL(Alis,0) = 0 AND IsDeleted = 0

SELECT COUNT(*) FROM Cari.Islemler WHERE IsDeleted = 0 AND (ISNULL(UsdKur,0) = 0 OR ISNULL(HasKur,0) = 0) AND Tarih >= DATEADD(month,-3,GETDATE())

SELECT COUNT(*) FROM (SELECT 'BakiyeIslem' AS Kaynak, COUNT(*) AS Adet FROM Cari.BakiyeIslem B
WHERE B.IslemId <> -1 AND NOT EXISTS (SELECT 1 FROM Cari.Islemler I WHERE I.Id = B.IslemId)
UNION ALL
SELECT 'StokHaraketleri(Bolum=0)', COUNT(*) FROM Stok.StokHaraketleri H
WHERE H.Bolum = 0 AND H.IslemId <> -1 AND NOT EXISTS (SELECT 1 FROM Cari.Islemler I WHERE I.Id = H.IslemId)) x

SELECT COUNT(*) FROM Sistem.UserDetails D WHERE D.IsDeleted = 0 AND (NOT EXISTS (SELECT 1 FROM Sistem.Users U WHERE U.Id = D.UserId) OR NOT EXISTS (SELECT 1 FROM Sistem.Subeler S WHERE S.Id = D.SubeId) OR NOT EXISTS (SELECT 1 FROM Sistem.Kasalar K WHERE K.Id = D.KasaId) OR NOT EXISTS (SELECT 1 FROM Sistem.UserGroup G WHERE G.Id = D.GroupId))

SELECT COUNT(DISTINCT CONCAT(d.referencing_id,'|',d.referenced_schema_name,'.',d.referenced_entity_name)) FROM sys.sql_expression_dependencies d WHERE d.referenced_id IS NULL AND d.is_ambiguous = 0 AND d.referenced_class = 1 AND (d.referenced_database_name IS NULL OR d.referenced_database_name = DB_NAME()) AND ISNULL(d.referenced_schema_name,'') NOT IN ('sys','INFORMATION_SCHEMA')

SELECT COUNT(*) FROM (SELECT DISTINCT d.referenced_database_name AS db FROM sys.sql_expression_dependencies d WHERE d.referenced_database_name IS NOT NULL AND d.referenced_database_name NOT IN (DB_NAME(),'master','msdb','tempdb')) x WHERE DB_ID(x.db) IS NULL

SELECT COUNT(*) FROM sys.triggers WHERE is_disabled = 1 AND parent_class = 1

SELECT 4 - COUNT(*) FROM sys.triggers WHERE parent_id = OBJECT_ID('Cari.Islemler') AND name IN ('AcceptTransaction','InsertTransaction','UpdateTransaction','DeleteTransaction')

SELECT COUNT(*) FROM (VALUES ('Sistem.CreateKasa'),('Cari.HesapInsert'),('Cari.HesapUpdate'),('Cari.TransferUpdateSTatus'),('Uretim.TrBakiyeHesapla'),('Siparis.Kontrol'),('Sistem.SilOnayUpdateTrigger'),('AifaDev.ExQueryBuilder')) v(n) WHERE OBJECT_ID(v.n) IS NULL

SELECT CAST(is_recursive_triggers_on AS int) FROM sys.databases WHERE name = DB_NAME()

SELECT COUNT(*) FROM (VALUES (N'Agent.Agent'),(N'Agent.Controller'),(N'Agent.FeedBack'),(N'AifaDev.Dashboard'),(N'AifaDev.DosReport'),(N'AifaDev.DosReportFields'),(N'AifaDev.DynamicForms'),(N'AifaDev.FaturaDesign'),(N'AifaDev.FormSize'),(N'AifaDev.Forms'),(N'AifaDev.GridLayouts'),(N'AifaDev.Layouts'),(N'AifaDev.ReportLayouts'),(N'AifaDev.Reports'),(N'AifaDev.ReportsFilter'),(N'AifaDev.RepositoryData'),(N'AifaDev.RepositoryItems'),(N'AifaDev.RibbonGroup'),(N'AifaDev.RibbonItem'),(N'AifaDev.RibbonPage'),(N'Bakiye.GetBakiye'),(N'Bakiye.GetDateOfBakiye'),(N'Bakiye.GetFisBakiyesi'),(N'Bakiye.GetVadeliBakiye'),(N'Bilanco.BilancoDevirleri'),(N'Bilanco.BilancoListesi'),(N'Bilanco.Bilancolar'),(N'Bilanco.GetKurFarki'),(N'Bilanco.OzetBilanco'),(N'Bilanco.Patron'),(N'Bilanco.SaveAll'),(N'Cari.AccountLog'),(N'Cari.AnaBakiyeIslem'),(N'Cari.BakiyeIslem'),(N'Cari.DosyaBilgileri'),(N'Cari.ExLimit'),(N'Cari.FaturaBilgileri'),(N'Cari.FaturaDetay'),(N'Cari.FaturaYaz'),(N'Cari.Faturalar'),(N'Cari.FindTaxInfo'),(N'Cari.FisIslemDetay'),(N'Cari.Fiyatlar'),(N'Cari.GelenIslemler'),(N'Cari.GetAccountLog'),(N'Cari.GetBakiyeDetay'),(N'Cari.GetEFaturaBilgileri'),(N'Cari.GetEfaturaListesi'),(N'Cari.GetFaturaBilgileri'),(N'Cari.GetFaturaDetay'),(N'Cari.GetFaturaListesi'),(N'Cari.GetFisPesinKontrol'),(N'Cari.GetFiyatListesi'),(N'Cari.GetGunlukNetBakiyeler'),(N'Cari.GetHesapListesi'),(N'Cari.GetHesaplar'),(N'Cari.GetIslemler'),(N'Cari.GetMarginKontrol'),(N'Cari.GetNewSiraNo'),(N'Cari.GetProformaDetay'),(N'Cari.GetProformaListesi'),(N'Cari.GetProvizyon'),(N'Cari.GetTransferler'),(N'Cari.GidenIslemler'),(N'Cari.HesapBilgileri'),(N'Cari.HesapListesi'),(N'Cari.Hesaplar'),(N'Cari.History'),(N'Cari.HistoryDetails'),(N'Cari.HistoryListesi'),(N'Cari.IslemDetaylari'),(N'Cari.IslemListesi'),(N'Cari.Islemler'),(N'Cari.Kartlar'),(N'Cari.Proforma'),(N'Cari.ProformaDetay'),(N'Cari.Provizyon'),(N'Cari.RSAktar'),(N'Cari.Teminatlar'),(N'Cari.Transferler'),(N'Design.FormControls'),(N'Design.Forms'),(N'Design.GetRibb

SELECT COUNT(*) FROM (VALUES (N'Bakiye.GetBakiyeFisNo'),(N'Cari.BakiyeDun'),(N'Cari.BakiyeGun'),(N'Cari.BakiyeKodlari'),(N'Cari.GetFaturaTutarlari'),(N'Cari.GetGerekliEvraklar'),(N'Cari.GetProformaTutarlari'),(N'Cari.GetTotalBalance'),(N'Cari.Istatistik'),(N'Cari.RSReferans'),(N'Cari.ToplamBakiye'),(N'FN.GenerateTakozCode'),(N'FN.GetKur'),(N'FN.Katsayı'),(N'FN.OlcuHesapla'),(N'Finans.BankaAltinOperasyonMiktarlari'),(N'Genel.DokumanIzinDetay'),(N'LiveUpdate.VersionHistory'),(N'Muhasebe.EDovizKontrolRaporuBTrans'),(N'Muhasebe.Islemler'),(N'Muhasebe.IslemlerBTrans'),(N'Muhasebe.StokHaraketleri'),(N'NET.GetPrice'),(N'NET.NetSiparisOzet'),(N'Organizasyon.GetOrganizasyonAdi'),(N'Pozisyon.Pozisyonlar'),(N'Sistem.Activity'),(N'Sistem.GetBirimToId'),(N'Sistem.GetIdToBirim'),(N'Sistem.GetLastKur'),(N'Sistem.GetMizanBakiye'),(N'Sistem.GetMizanBakiyeIslem'),(N'Sistem.GetMizanBakiyeleri'),(N'Sistem.MizanCTE'),(N'Stok.DevirCesniStoklari'),(N'Stok.GetMadenMaliyeti'),(N'Stok.GetOrtMilyem'),(N'Stok.GetTakozAdet'),(N'Stok.GetTakozSirketStoklari'),(N'Uretim.BakiyeDetay'),(N'Uretim.KatkiHesapla'),(N'dbo.BakiyeIslem'),(N'dbo.Pano'),(N'dbo.YaziIle')) v(n) WHERE OBJECT_ID(v.n) IS NULL

SELECT COUNT(*) FROM (VALUES (N'Cari.GETOdemeKasaOzeti'),(N'Cari.GETOdemeListesi'),(N'Cari.GetRiskRaporu'),(N'Cari.Odemeler'),(N'Genel.IptalOnay'),(N'Organizasyon.GelenGorevler'),(N'Organizasyon.GidenGorevler'),(N'Organizasyon.GorevDagitim'),(N'Organizasyon.Gorevler'),(N'Siparis.FiyatListesi'),(N'Siparis.GetFiyatListesi'),(N'Siparis.GetLastPrice'),(N'Siparis.GetPaketHesapListesi'),(N'Siparis.GetUyumluPaketler'),(N'Siparis.ModelAyarBlackList'),(N'Siparis.PaketHesaplari'),(N'Siparis.modelayarBlacklist'),(N'Sistem.iException'),(N'Stok.GetTakozIsciligi'),(N'Uretim.Eritme'),(N'Uretim.Formul'),(N'Uretim.FormulDetay'),(N'Uretim.GetEritmeListesi'),(N'Uretim.GetFormulDetay'),(N'Uretim.GetFormuls'),(N'Uretim.GetModelPartiBilgiListesi'),(N'Uretim.GetPartiModelListesi'),(N'Uretim.GetPartiler'),(N'Uretim.ModelPartiBilgileri'),(N'Uretim.Partiler')) v(n) WHERE OBJECT_ID(v.n) IS NULL

SELECT COUNT(*) FROM (VALUES (N'Cari.Transferler',N'Aciklama'),(N'Siparis.Paket',N'IsPublic'),(N'Siparis.TakimKartlari',N'Grup'),(N'Sistem.CariIslemTipi',N'IsDeleted'),(N'Cari.Provizyon',N'IsDeleted'),(N'Sistem.Users',N'SubeId'),(N'Cari.IslemDetaylari',N'ETTN'),(N'Cari.Islemler',N'IsArbitiraj')) v(t,c) WHERE COL_LENGTH(v.t, v.c) IS NULL

SELECT ABS(1 - (SELECT COUNT(*) FROM Sistem.Settings))

SELECT COUNT(*) FROM (SELECT s.HasSymbol AS k UNION ALL SELECT s.GumSymbol UNION ALL SELECT s.UsdSymbol UNION ALL SELECT s.EurSymbol UNION ALL SELECT s.PltSymbol UNION ALL SELECT s.PldSymbol FROM (SELECT TOP 1 * FROM Sistem.Settings) s) x WHERE x.k IS NOT NULL AND (SELECT COUNT(*) FROM Sistem.Birimler b WHERE b.IsDeleted = 0 AND b.Kodu = x.k) <> 1

SELECT 1 - COUNT(*) FROM Sistem.Users WHERE Id = 1

SELECT CASE WHEN (SELECT COUNT(*) FROM Sistem.CariIslemKodu) = 0 OR (SELECT COUNT(*) FROM Sistem.CariIslemTuru) = 0 OR (SELECT COUNT(*) FROM Sistem.CariIslemTipi) = 0 THEN 1 ELSE 0 END

SELECT COUNT(*) FROM (SELECT TOP 1 OnsCarpan, BSMV FROM Sistem.Settings) s WHERE ISNULL(s.OnsCarpan,0) NOT BETWEEN 31.10 AND 31.11 OR ISNULL(s.BSMV,0) NOT BETWEEN 0 AND 10

SELECT COUNT(*) - COUNT(DISTINCT k.cols) FROM (SELECT i.index_id, STUFF((SELECT ',' + c.name FROM sys.index_columns ic JOIN sys.columns c ON c.object_id = ic.object_id AND c.column_id = ic.column_id WHERE ic.object_id = i.object_id AND ic.index_id = i.index_id AND ic.is_included_column = 0 ORDER BY ic.key_ordinal FOR XML PATH('')),1,1,'') AS cols FROM sys.indexes i WHERE i.object_id = OBJECT_ID('Cari.Islemler') AND i.index_id > 0) k

SELECT COUNT(*) FROM AifaDev.RepositoryData D JOIN AifaDev.RepositoryItems I ON I.Id = D.ItemId WHERE I.DataType IN (2,4,5) AND TRY_CONVERT(decimal(18,5), D.Value) IS NULL AND D.Value IS NOT NULL

SELECT COUNT(*) FROM sys.columns WHERE system_type_id IN (35,34,99)