SQL Server Hataları

SELECT OBJECT_ID('Cari.Odemeler') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Genel.IptalOnay') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Siparis.FiyatListesi') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Uretim.Eritme') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Uretim.Formul') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Uretim.FormulDetay') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Uretim.ModelPartiBilgileri') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Uretim.Partiler') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Siparis.GetFiyatListesi') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Uretim.GetEritmeListesi') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Uretim.GetFormuls') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Uretim.GetModelPartiBilgiListesi') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Uretim.GetPartiler') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Cari.GETOdemeKasaOzeti') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Cari.GETOdemeListesi') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Organizasyon.Gorevler') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Organizasyon.GorevDagitim') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Sistem.iException') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Siparis.PaketHesaplari') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Siparis.ModelAyarBlackList') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Siparis.modelayarBlacklist') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Siparis.GetPaketHesapListesi') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Siparis.GetUyumluPaketler') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Siparis.GetLastPrice') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Uretim.GetFormulDetay') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Uretim.GetPartiModelListesi') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Cari.GetRiskRaporu') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Stok.GetTakozIsciligi') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Organizasyon.GelenGorevler') AS ObjId; -- NULL ise nesne yok

SELECT OBJECT_ID('Organizasyon.GidenGorevler') AS ObjId; -- NULL ise nesne yok

SELECT name FROM sys.databases WHERE name='DOCUMENTS'; SELECT OBJECT_DEFINITION(OBJECT_ID('Genel.Dosyalar')); SELECT TOP 1 * FROM Genel.Dosyalar; -- hata verirse kırık

SELECT OBJECT_ID('LiveUpdate.VersionHistory'), OBJECT_ID('LiveUpdate.VersionHistory_');

SELECT COUNT(*) FROM sys.columns WHERE object_id=OBJECT_ID('Cari.Hesaplar'); -- 57; proc metnindeki select listesi 41 değer

SELECT referenced_schema_name, referenced_entity_name FROM sys.sql_expression_dependencies WHERE referencing_id=OBJECT_ID('dbo.sp_DevirIslemiYap') AND referenced_id IS NULL;

SELECT OBJECT_ID('Sistem.MT4Orders'), OBJECT_ID('Sistem.MT4Tickets');

SELECT Id,ReportName FROM AifaDev.Reports WHERE Query LIKE '%GetEnvanter%' OR Query LIKE '%GetCariBakiyeHaraketleri%' OR Query LIKE '%IptalIslemRaporu%' OR Query LIKE '%HesapExtresiDetails%';

SELECT p.name FROM sys.parameters p WHERE p.object_id=OBJECT_ID('Reports.GetPozisyonDetay'); -- 3 satır beklenir

SELECT Id FROM AifaDev.Reports WHERE Query LIKE '%ResmiPozisyon ()%';

SELECT DISTINCT [Owner] FROM AifaDev.RepositoryItems WHERE IsDeleted=0 AND OBJECT_ID('Query.'+[Owner]) IS NULL; -- view'ı olmayan owner'lar

SELECT COL_LENGTH('Cari.Transferler','Aciklama'); -- NULL ise kolon yok

SELECT COL_LENGTH('Siparis.Paket','IsPublic'); -- NULL ise kolon yok

SELECT COL_LENGTH('Siparis.TakimKartlari','Grup'); -- NULL ise kolon yok

SELECT COL_LENGTH('Sistem.CariIslemTipi','IsDeleted'); -- NULL ise kolon yok

SELECT COL_LENGTH('Cari.Provizyon','IsDeleted'); -- NULL ise kolon yok

SELECT COL_LENGTH('Sistem.Users','SubeId'); -- NULL ise kolon yok

SELECT COL_LENGTH('Cari.IslemDetaylari','ETTN') AS ETTN, COL_LENGTH('Cari.Islemler','IsArbitiraj') AS IsArbitiraj;

SELECT TableName, ColumnName, DataType, Method FROM Sistem.ERPSCHEMA WHERE OBJECT_ID(TableName) IS NOT NULL ORDER BY TableName;

SELECT COUNT(*) FROM Cari.Islemler WHERE IsDeleted=0 AND (ISNULL(HasKur,0)=0 OR ISNULL(IscilikBirimKur,0)=0) AND IslemKodu=0; -- takoz işlemlerinde kur 0

SELECT Tarih FROM Sistem.Kurlar WHERE BirimId=1 AND ISNULL(Alis,0)=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 Cari.Islemler WHERE Tag IS NOT NULL AND TRY_CONVERT(int,Tag) IS NULL;

SELECT D.* 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 MAX(ABS(Tutar*ISNULL(HasKur,0))) FROM Cari.Islemler;

SELECT type_desc FROM sys.objects WHERE object_id=OBJECT_ID('Sistem.TCMBDovizKurlari'); SELECT COUNT(*) FROM Sistem.NonUsed_TCMBDovizKurlari;

SELECT s.name,t.name,c.name,c.max_length/2 AS chars FROM sys.columns c JOIN sys.tables t ON t.object_id=c.object_id JOIN sys.schemas s ON s.schema_id=t.schema_id WHERE c.system_type_id=231 AND c.max_length BETWEEN 1 AND 100 AND c.name IN ('Aciklama','Kodu','Email') ORDER BY chars;

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

SELECT BirimId,Tarih,COUNT(*) FROM Sistem.Kurlar GROUP BY BirimId,Tarih HAVING COUNT(*)>1; SELECT Kodu,COUNT(*) FROM Sistem.Birimler WHERE IsDeleted=0 GROUP BY Kodu HAVING COUNT(*)>1; SELECT FisNo,COUNT(DISTINCT RefNo) FROM Cari.Islemler WHERE IsDeleted=0 GROUP BY FisNo HAVING COUNT(DISTINCT RefNo)>1;

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

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

SELECT Id,UserName FROM Sistem.Users WHERE Id=1; SELECT * FROM Sistem.UserDetails WHERE UserId NOT IN (SELECT Id FROM Sistem.Users);

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

SELECT VergiNo,SubeId,COUNT(*) FROM Cari.Hesaplar WHERE IsDeleted=0 AND VergiNo IS NOT NULL GROUP BY VergiNo,SubeId HAVING COUNT(*)>1;

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

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

SELECT Kodu FROM Cari.BakiyeKodlari WHERE Kodu LIKE '%[]]%' OR Kodu LIKE '%[[]%';

SELECT LEN(OBJECT_DEFINITION(OBJECT_ID('Cari.AcceptTransaction'))); -- 29.862 (DB1) vs 31.152 (DB2)

SELECT i.name,i.type_desc,STRING_AGG(c.name,',') WITHIN GROUP (ORDER BY ic.key_ordinal) FROM sys.indexes i JOIN sys.index_columns ic ON ic.object_id=i.object_id AND ic.index_id=i.index_id JOIN sys.columns c ON c.object_id=ic.object_id AND c.column_id=ic.column_id WHERE i.object_id=OBJECT_ID('Cari.Islemler') AND ic.is_included_column=0 GROUP BY i.name,i.type_desc;

SELECT is_recursive_triggers_on FROM sys.databases WHERE name=DB_NAME(); SELECT VergiNo,SubeId,COUNT(*) FROM Cari.Hesaplar WHERE IsDeleted=0 AND ISNULL(VergiNo,'')<>'' GROUP BY VergiNo,SubeId HAVING COUNT(*)>2;

SELECT OBJECT_SCHEMA_NAME(parent_id)+'.'+OBJECT_NAME(parent_id) AS Tablo, name, is_disabled FROM sys.triggers ORDER BY 1;

SELECT referenced_schema_name+'.'+referenced_entity_name FROM sys.sql_expression_dependencies WHERE referencing_id=OBJECT_ID('Cari.AcceptTransaction') AND referenced_id IS NULL;

SELECT DATABASEPROPERTYEX(DB_NAME(),'Collation'), SERVERPROPERTY('Collation');

SELECT OBJECT_NAME(object_id),name FROM sys.columns WHERE system_type_id IN (35,34,99);

SELECT OBJECT_ID('Pozisyon.GetOldPozisyon'); SELECT COUNT(*) FROM Sistem.NonUsed_TCMBDovizKurlari;