SQL – AHMET AYDINLIK

31Ara

SQL Server Trigger Listesi

Aşağıdaki script Sql server attachlı olan tüm database lerdeki trigger ların listesini verir

DECLARE @sql NVARCHAR(MAX) = N'';

SELECT @sql = @sql + '
USE ' + QUOTENAME(name) + ';

IF EXISTS (SELECT 1 FROM sys.triggers WHERE is_ms_shipped = 0)
BEGIN
    SELECT
        ''' + name + ''' AS DatabaseName,
        s.name AS SchemaName,
        o.name AS ObjectName,
        o.type_desc AS ObjectType,
        tr.name AS TriggerName,
        tr.is_instead_of_trigger,
        tr.is_disabled,
        tr.create_date,
        tr.modify_date
    FROM sys.triggers tr
    JOIN sys.objects o ON tr.parent_id = o.object_id
    JOIN sys.schemas s ON o.schema_id = s.schema_id
    WHERE tr.is_ms_shipped = 0
      AND (
            tr.is_instead_of_trigger = 1
            OR OBJECT_DEFINITION(tr.object_id) LIKE ''%INSERT%''
            OR OBJECT_DEFINITION(tr.object_id) LIKE ''%DELETE%''
          );
END
'
FROM sys.databases
WHERE state = 0
AND database_id > 4;

EXEC sp_executesql @sql;

SQL
MSSQL, sql, table size

19Mar

Sql Server Tablo Boyutlarını Gösteren Sorgu

Aşağıdaki Sql Scriptini Kullanarak Hangi Tabloda Kaç Satır var MB olarak Ne Kadar Yer Kaplıyor öğrenebilirsiniz

SELECT 
    t.NAME AS TableName,
    s.Name AS SchemaName,
    p.rows AS RowCounts,
    (SUM(a.total_pages) * 8) / 1024 AS TotalSizeMB,
    (SUM(a.used_pages) * 8) / 1024 AS UsedSizeMB,
    (SUM(a.data_pages) * 8) / 1024 AS DataSizeMB
FROM 
    sys.tables t
INNER JOIN 
    sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN 
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
INNER JOIN 
    sys.allocation_units a ON p.partition_id = a.container_id
INNER JOIN 
    sys.schemas s ON t.schema_id = s.schema_id
WHERE 
    t.is_ms_shipped = 0
GROUP BY 
    t.Name, s.Name, p.Rows
ORDER BY 
    TotalSizeMB DESC;

17Oca

Databasedeki Tüm İndexleri Create Kodu ile Alma SQL Script

Bu script ile Sql Server daki Database ait tüm NONCLUSTERED indexleri listeleyip create kodlarını alabilirsiniz

SELECT 
    DB_NAME() AS DatabaseName, -- Veritabanı adı
    OBJECT_SCHEMA_NAME(i.object_id) + '.' + OBJECT_NAME(i.object_id) AS TableName, -- Şema ve tablo adı
    i.name AS IndexName, -- İndeks adı
    'CREATE ' + 
    CASE WHEN i.is_unique = 1 THEN 'UNIQUE ' ELSE '' END + 
    'NONCLUSTERED INDEX [' + i.name + '] ON ' + 
    OBJECT_SCHEMA_NAME(i.object_id) + '.' + OBJECT_NAME(i.object_id) +
    ' (' + 
    STUFF((
        SELECT ', ' + c.name
        FROM sys.index_columns ic
        JOIN sys.columns c ON ic.object_id = c.object_id AND ic.column_id = c.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(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 2, '') +
    ')' +
    CASE 
        WHEN EXISTS (
            SELECT 1
            FROM sys.index_columns ic2
            WHERE ic2.object_id = i.object_id AND ic2.index_id = i.index_id AND ic2.is_included_column = 1
        ) THEN 
        ' INCLUDE (' + 
        STUFF((
            SELECT ', ' + c2.name
            FROM sys.index_columns ic2
            JOIN sys.columns c2 ON ic2.object_id = c2.object_id AND ic2.column_id = c2.column_id
            WHERE ic2.object_id = i.object_id AND ic2.index_id = i.index_id AND ic2.is_included_column = 1
            FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 2, '') + 
        ')' 
        ELSE '' 
    END AS CreateIndexScript
FROM 
    sys.indexes i
WHERE 
    i.type = 2 -- Non-clustered indeksler
ORDER BY 
    DatabaseName, TableName, IndexName;

SQL
mssql server, sql, sql server

30Ara

Sql Server İçinde Veri Olan Tablolar

Sql server database inin içindeki tablolardaki kayıt sayılarını verir

SELECT 
    s.name AS SchemaName,
    t.name AS TableName,
    SUM(p.rows) AS [RowCount]
FROM sys.tables t
JOIN sys.schemas s ON t.schema_id = s.schema_id
JOIN sys.partitions p ON t.object_id = p.object_id
WHERE p.index_id IN (0, 1) -- 0: Heap, 1: Clustered Index
GROUP BY s.name, t.name
HAVING SUM(p.rows) > 0
ORDER BY [RowCount] DESC;

SQL
Index, mssql server, rebuild Index, sql

29Nis

SQL Server Tüm İndexler Rebuild

Veritabanında bulunan indexleri aşağıdaki script ile kolayca rebuild yapabilirsiniz

USE [VeritabanıAdı];
GO

DECLARE @TableName NVARCHAR(255);
DECLARE table_cursor CURSOR FOR 
SELECT name FROM sys.tables;

OPEN table_cursor;
FETCH NEXT FROM table_cursor INTO @TableName;

WHILE @@FETCH_STATUS = 0  
BEGIN  
       EXEC ('ALTER INDEX ALL ON ' + @TableName + ' REBUILD;');
       FETCH NEXT FROM table_cursor INTO @TableName; 
END;

CLOSE table_cursor;  
DEALLOCATE table_cursor; 
GO

7Şub

ISO ÜLKE KODLARI

ÜLKELERİN İSO KODLARINI TABLO İÇERSİNE ALMAYA YARAYAN SCRİPT MS-SQL SERVER İÇİNDİR BİRAZ DÜZENLEYİP FARKLI VERİ TABANLARINDA DA KULLANILABİLİR

CREATE TABLE [dbo].[EF_ULKE](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[ULKE_EN] [nvarchar](255) NULL,
	[ULKE_TR] [nvarchar](255) NULL,
	[ALPHA2] [nvarchar](50) NULL,
	[ALPHA3] [nvarchar](50) NULL,
	[NUMBER] [int] NULL,
 CONSTRAINT [PK_EF_ULKE] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY]
) ON [PRIMARY]
GO

/***Insert Country Iso Code Table***/
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('AFGHANISTAN','AFGANİSTAN','AF','AFG',4)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ALBANIA','ARNAVUTLUK','AL','ALB',8)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ALGERIA','CEZAYİR','DZ','DZA',12)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('AMERICAN SAMOA','AMERİKAN SAMOASI','AS','ASM',16)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ANDORRA','ANDORRA','AD','AND',20)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ANGOLA','ANGOLA','AO','AGO',24)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ANGUILLA','ANGUİLLA','AI','AIA',660)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ANTARCTICA','ANTARKTİKA','AQ','ATA',10)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ANTIGUA AND BARBUDA','ANTİGUA VE BARBUDA','AG','ATG',28)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ARGENTINA','ARJANTİN','AR','ARG',32)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ARMENIA','ERMENİSTAN','AM','ARM',51)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ARUBA','ARUBA','AW','ABW',533)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('AUSTRALIA','AVUSTRALYA','AU','AUS',36)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('AUSTRIA','AVUSTURYA','AT','AUT',40)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('AZERBAIJAN','AZERBAYCAN','AZ','AZE',31)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BAHAMAS ','BAHAMALAR ','BS','BHS',44)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BAHRAIN','BAHREYN','BH','BHR',48)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BANGLADESH','BANGLADEŞ','BD','BGD',50)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BARBADOS','BARBADOS','BB','BRB',52)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BELARUS','BELARUS','BY','BLR',112)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BELGIUM','BELÇİKA','BE','BEL',56)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BELIZE','BELİZE','BZ','BLZ',84)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BENIN','BENİN','BJ','BEN',204)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BERMUDA','BERMUDA','BM','BMU',60)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BHUTAN','BUTAN','BT','BTN',64)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BOLIVIA (PLURINATIONAL STATE OF)','BOLİVYA (PLURİNATİONAL DURUM)','BO','BOL',68)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BONAIRE, SINT EUSTATIUS AND SABA','BONAİRE, SİNT EUSTATİUS VE SABA','BQ','BES',535)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BOSNIA AND HERZEGOVINA','BOSNA HERSEK','BA','BIH',70)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BOTSWANA','BOTSVANA','BW','BWA',72)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BOUVET ISLAND','BOUVET ADASI','BV','BVT',74)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BRAZIL','BREZİLYA','BR','BRA',76)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BRITISH INDIAN OCEAN TERRITORY ','İNGİLİZ HİNT OKYANUSU BÖLGESİ ','IO','IOT',86)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BRUNEI DARUSSALAM','BRUNEİ DARUSSALAM','BN','BRN',96)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BULGARIA','BULGARİSTAN','BG','BGR',100)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BURKINA FASO','BURKİNA FASO','BF','BFA',854)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('BURUNDI','BURUNDİ','BI','BDI',108)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CABO VERDE','CABO VERDE','CV','CPV',132)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CAMBODIA','KAMBOÇYA','KH','KHM',116)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CAMEROON','KAMERUN','CM','CMR',120)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CANADA','KANADA','CA','CAN',124)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CAYMAN ISLANDS ','CAYMAN ADALARI ','KY','CYM',136)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CENTRAL AFRICAN REPUBLIC ','ORTA AFRİKA CUMHURİYETİ ','CF','CAF',140)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CHAD','ÇAD','TD','TCD',148)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CHILE','ŞİLİ','CL','CHL',152)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CHINA','ÇİN','CN','CHN',156)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CHRISTMAS ISLAND','NOEL ADASI','CX','CXR',162)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('COCOS (KEELING) ISLANDS ','COCOS (KEELİNG) ADALARI ','CC','CCK',166)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('COLOMBIA','KOLOMBİYA','CO','COL',170)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('COMOROS ','COMOROS ','KM','COM',174)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CONGO (THE DEMOCRATIC REPUBLIC OF THE)','KONGO (DEMOKRATİK CUMHURİYETİ)','CD','COD',180)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CONGO ','KONGO ','CG','COG',178)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('COOK ISLANDS ','COOK ADALARI ','CK','COK',184)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('COSTA RICA','KOSTA RİKA','CR','CRI',188)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CROATIA','HIRVATİSTAN','HR','HRV',191)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CUBA','KÜBA','CU','CUB',192)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CURAÇAO','CURACAO','CW','CUW',531)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CYPRUS','KIBRIS','CY','CYP',196)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CZECHIA','ÇEKYA','CZ','CZE',203)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('CÔTE D''IVOIRE','FİLDİŞİ SAHİLLERİ','CI','CIV',384)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('DENMARK','DANİMARKA','DK','DNK',208)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('DJIBOUTI','DJİBOUTİ','DJ','DJI',262)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('DOMINICA','DOMİNİKA','DM','DMA',212)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('DOMINICAN REPUBLIC ','DOMİNİK CUMHURİYETİ ','DO','DOM',214)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ECUADOR','EKVADOR','EC','ECU',218)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('EGYPT','MISIR','EG','EGY',818)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('EL SALVADOR','EL SALVADOR','SV','SLV',222)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('EQUATORIAL GUINEA','EKVATOR GİNESİ','GQ','GNQ',226)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ERITREA','ERİTRE','ER','ERI',232)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ESTONIA','ESTONYA','EE','EST',233)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ESWATINI','ESWATİNİ','SZ','SWZ',748)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ETHIOPIA','ETİYOPYA','ET','ETH',231)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('FALKLAND ISLANDS  [MALVINAS]','FALKLAND ADALARI  [MALVİNAS]','FK','FLK',238)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('FAROE ISLANDS ','FAROE ADALARI ','FO','FRO',234)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('FIJI','FİJİ','FJ','FJI',242)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('FINLAND','FİNLANDİYA','FI','FIN',246)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('FRANCE','FRANSA','FR','FRA',250)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('FRENCH GUIANA','FRANSIZ GUYANASI','GF','GUF',254)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('FRENCH POLYNESIA','FRANSIZ POLİNEZYASI','PF','PYF',258)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('FRENCH SOUTHERN TERRITORIES ','FRANSIZ GÜNEY BÖLGELERİ ','TF','ATF',260)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GABON','GABON','GA','GAB',266)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GAMBIA ','GAMBİYA ','GM','GMB',270)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GEORGIA','GÜRCİSTAN','GE','GEO',268)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GERMANY','ALMANYA','DE','DEU',276)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GHANA','GANA','GH','GHA',288)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GIBRALTAR','CEBELİTARIK','GI','GIB',292)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GREECE','YUNANİSTAN','GR','GRC',300)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GREENLAND','GRÖNLAND','GL','GRL',304)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GRENADA','GRENADA','GD','GRD',308)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GUADELOUPE','GUADELOUPE','GP','GLP',312)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GUAM','GUAM','GU','GUM',316)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GUATEMALA','GUATEMALA','GT','GTM',320)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GUERNSEY','GUERNSEY','GG','GGY',831)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GUINEA','GİNE','GN','GIN',324)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GUINEA-BISSAU','GİNE-BİSSAU','GW','GNB',624)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('GUYANA','GUYANA','GY','GUY',328)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('HAITI','HAİTİ','HT','HTI',332)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('HEARD ISLAND AND MCDONALD ISLANDS','HEARD ISLAND VE MCDONALD ADALARI','HM','HMD',334)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('HOLY SEE ','HOLY SEE ','VA','VAT',336)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('HONDURAS','HONDURAS','HN','HND',340)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('HONG KONG','HONG KONG','HK','HKG',344)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('HUNGARY','MACARİSTAN','HU','HUN',348)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ICELAND','İZLANDA','IS','ISL',352)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('INDIA','HİNDİSTAN','IN','IND',356)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('INDONESIA','ENDONEZYA','ID','IDN',360)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('IRAN (ISLAMIC REPUBLIC OF)','İRAN (İSLAM CUMHURİYETİ)','IR','IRN',364)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('IRAQ','IRAK','IQ','IRQ',368)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('IRELAND','İRLANDA','IE','IRL',372)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ISLE OF MAN','ADAM','IM','IMN',833)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ISRAEL','İSRAİL','IL','ISR',376)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ITALY','İTALYA','IT','ITA',380)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('JAMAICA','JAMAİKA','JM','JAM',388)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('JAPAN','JAPONYA','JP','JPN',392)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('JERSEY','JERSEY','JE','JEY',832)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('JORDAN','ÜRDÜN','JO','JOR',400)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('KAZAKHSTAN','KAZAKİSTAN','KZ','KAZ',398)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('KENYA','KENYA','KE','KEN',404)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('KIRIBATI','KİRİBATİ','KI','KIR',296)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('KOREA (THE DEMOCRATIC PEOPLE''S REPUBLIC OF)','KORE (DEMOKRATİK HALK CUMHURİYETİ)','KP','PRK',408)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('KOREA (THE REPUBLIC OF)','KORE (CUMHURİYETİ)','KR','KOR',410)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('KUWAIT','KUVEYT','KW','KWT',414)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('KYRGYZSTAN','KIRGIZİSTAN','KG','KGZ',417)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('LAO PEOPLE''S DEMOCRATIC REPUBLIC ','LAO HALK DEMOKRATİK CUMHURİYETİ ','LA','LAO',418)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('LATVIA','LETONYA','LV','LVA',428)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('LEBANON','LÜBNAN','LB','LBN',422)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('LESOTHO','LESOTO','LS','LSO',426)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('LIBERIA','LİBERYA','LR','LBR',430)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('LIBYA','LİBYA','LY','LBY',434)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('LIECHTENSTEIN','LİHTENŞİST','LI','LIE',438)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('LITHUANIA','LİTVANYA','LT','LTU',440)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('LUXEMBOURG','LÜKSEMBURG','LU','LUX',442)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MACAO','MACAO','MO','MAC',446)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MADAGASCAR','MADAGASKAR','MG','MDG',450)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MALAWI','MALAWİ','MW','MWI',454)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MALAYSIA','MALEZYA','MY','MYS',458)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MALDIVES','MALDİVLER','MV','MDV',462)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MALI','MALİ','ML','MLI',466)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MALTA','MALTA','MT','MLT',470)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MARSHALL ISLANDS ','MARSHALL ADALARI ','MH','MHL',584)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MARTINIQUE','MARTİNİK','MQ','MTQ',474)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MAURITANIA','MORİTANYA','MR','MRT',478)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MAURITIUS','MAURİTİUS','MU','MUS',480)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MAYOTTE','MAYOTTE','YT','MYT',175)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MEXICO','MEKSİKA','MX','MEX',484)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MICRONESIA (FEDERATED STATES OF)','MİKRONEZYA (FEDERASYONLU DURUMLAR)','FM','FSM',583)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MOLDOVA (THE REPUBLIC OF)','MOLDOVA (CUMHURİYETİ)','MD','MDA',498)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MONACO','MONAKO','MC','MCO',492)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MONGOLIA','MOĞOLİSTAN','MN','MNG',496)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MONTENEGRO','KARADAĞ','ME','MNE',499)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MONTSERRAT','MONTSERRAT','MS','MSR',500)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MOROCCO','FAS','MA','MAR',504)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MOZAMBIQUE','MOZAMBİK','MZ','MOZ',508)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('MYANMAR','MYANMAR','MM','MMR',104)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('NAMIBIA','NAMİBYA','NA','NAM',516)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('NAURU','NAURU','NR','NRU',520)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('NEPAL','NEPAL','NP','NPL',524)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('NETHERLANDS (KINGDOM OF THE)','HOLLANDA (KRALLIK)','NL','NLD',528)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('NEW CALEDONIA','YENİ KALEDONYA','NC','NCL',540)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('NEW ZEALAND','YENİ ZELANDA','NZ','NZL',554)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('NICARAGUA','NİKARAGUA','NI','NIC',558)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('NIGER ','NİJER ','NE','NER',562)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('NIGERIA','NİJERYA','NG','NGA',566)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('NIUE','NİUE','NU','NIU',570)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('NORFOLK ISLAND','NORFOLK ADASI','NF','NFK',574)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('NORTH MACEDONIA','KUZEY MAKEDONYA','MK','MKD',807)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('NORTHERN MARIANA ISLANDS ','KUZEY MARİANA ADALARI ','MP','MNP',580)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('NORWAY','NORVEÇ','NO','NOR',578)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('OMAN','UMMAN','OM','OMN',512)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('PAKISTAN','PAKİSTAN','PK','PAK',586)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('PALAU','PALAU','PW','PLW',585)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('PALESTINE, STATE OF','FİLİSTİN, DURUMU','PS','PSE',275)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('PANAMA','PANAMA','PA','PAN',591)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('PAPUA NEW GUINEA','PAPUA YENİ GİNE','PG','PNG',598)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('PARAGUAY','PARAGUAY','PY','PRY',600)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('PERU','PERU','PE','PER',604)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('PHILIPPINES ','FİLİPİNLER ','PH','PHL',608)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('PITCAIRN','ÇUKUR','PN','PCN',612)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('POLAND','POLONYA','PL','POL',616)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('PORTUGAL','PORTEKİZ','PT','PRT',620)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('PUERTO RICO','PORTO RİKO','PR','PRI',630)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('QATAR','KATAR','QA','QAT',634)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ROMANIA','ROMANYA','RO','ROU',642)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('RUSSIAN FEDERATION ','RUSYA FEDERASYONU ','RU','RUS',643)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('RWANDA','RUANDA','RW','RWA',646)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('RÉUNION','RÉUNİON','RE','REU',638)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SAINT BARTHÉLEMY','SAİNT BARTHÉEMY','BL','BLM',652)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA','SAİNT HELENA, YÜKSELİŞ VE TRİSTAN DA CUNHA','SH','SHN',654)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SAINT KITTS AND NEVIS','SAİNT KİTTS VE NEVİS','KN','KNA',659)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SAINT LUCIA','SAİNT LUCİA','LC','LCA',662)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SAINT MARTIN (FRENCH PART)','SAİNT MARTİN (FRANSIZ KISMI)','MF','MAF',663)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SAINT PIERRE AND MIQUELON','SAİNT PİERRE VE MİQUELON','PM','SPM',666)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SAINT VINCENT AND THE GRENADINES','SAİNT VİNCENT VE GRENADİNLER','VC','VCT',670)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SAMOA','SAMOA','WS','WSM',882)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SAN MARINO','SAN MARİNO','SM','SMR',674)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SAO TOME AND PRINCIPE','SAO TOME VE PRENSİP','ST','STP',678)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SAUDI ARABIA','SUUDİ ARABİSTAN','SA','SAU',682)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SENEGAL','SENEGAL','SN','SEN',686)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SERBIA','SIRBİSTAN','RS','SRB',688)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SEYCHELLES','SEYŞELLER','SC','SYC',690)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SIERRA LEONE','SİERRA LEONE','SL','SLE',694)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SINGAPORE','SİNGAPUR','SG','SGP',702)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SINT MAARTEN (DUTCH PART)','SİNT MAARTEN (HOLLANDA BÖLÜMÜ)','SX','SXM',534)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SLOVAKIA','SLOVAKYA','SK','SVK',703)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SLOVENIA','SLOVENYA','SI','SVN',705)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SOLOMON ISLANDS','SOLOMON ADALARI','SB','SLB',90)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SOMALIA','SOMALİ','SO','SOM',706)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SOUTH AFRICA','GÜNEY AFRİKA','ZA','ZAF',710)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','GÜNEY GEORGİA VE GÜNEY SANDVİÇ ADALARI','GS','SGS',239)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SOUTH SUDAN','GÜNEY SUDAN','SS','SSD',728)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SPAIN','İSPANYA','ES','ESP',724)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SRI LANKA','SRİ LANKA','LK','LKA',144)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SUDAN ','SUDAN ','SD','SDN',729)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SURINAME','SURİNAM','SR','SUR',740)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SVALBARD AND JAN MAYEN','SVALBARD VE JAN MAYEN','SJ','SJM',744)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SWEDEN','İSVEÇ','SE','SWE',752)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SWITZERLAND','İSVİÇRE','CH','CHE',756)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('SYRIAN ARAB REPUBLIC ','SURİYE ARAP CUMHURİYETİ ','SY','SYR',760)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('TAIWAN (PROVINCE OF CHINA)','TAYVAN','TW','TWN',158)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('TAJIKISTAN','TACİKİSTAN','TJ','TJK',762)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('TANZANIA, THE UNITED REPUBLIC OF','TANZANYA, BİRLEŞİK CUMHURİYETİ','TZ','TZA',834)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('THAILAND','TAYLAND','TH','THA',764)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('TIMOR-LESTE','TİMOR-LESTE','TL','TLS',626)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('TOGO','GİTMEK','TG','TGO',768)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('TOKELAU','TOKELAU','TK','TKL',772)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('TONGA','TONGA','TO','TON',776)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('TRINIDAD AND TOBAGO','TRİNİDAD VE TOBAGO','TT','TTO',780)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('TUNISIA','TUNUS','TN','TUN',788)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('TURKMENISTAN','TÜRKMENİSTAN','TM','TKM',795)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('TURKS AND CAICOS ISLANDS ','TÜRKLER VE CAİCOS ADALARI ','TC','TCA',796)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('TUVALU','TUVALU','TV','TUV',798)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('TÜRKIYE','TÜRKİYE','TR','TUR',792)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('UGANDA','UGANDA','UG','UGA',800)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('UKRAINE','UKRAYNA','UA','UKR',804)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('UNITED ARAB EMIRATES ','BİRLEŞİK ARAP EMİRLİKLERİ ','AE','ARE',784)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('UNITED KINGDOM OF GREAT BRITAIN AND NORTHERN IRELAND ','İNGİLTERE VE KUZEY İRLANDA BİRLEŞİK KRALLIĞI ','GB','GBR',826)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('UNITED STATES MINOR OUTLYING ISLANDS ','AMERİKA BİRLEŞİK DEVLETLERİ KÜÇÜK DIŞ ADALAR ','UM','UMI',581)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('UNITED STATES OF AMERICA ','AMERİKA BİRLEŞİK DEVLETLERİ ','US','USA',840)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('URUGUAY','URUGUAY','UY','URY',858)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('UZBEKISTAN','ÖZBEKİSTAN','UZ','UZB',860)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('VANUATU','VANATU','VU','VUT',548)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('VENEZUELA (BOLIVARIAN REPUBLIC OF)','VENEZUELA (BOLİVAR CUMHURİYETİ)','VE','VEN',862)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('VIET NAM','VİET NAM','VN','VNM',704)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('VIRGIN ISLANDS (BRITISH)','VİRGİN ADALARI (İNGİLİZ)','VG','VGB',92)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('VIRGIN ISLANDS (U.S.)','VİRGİN ADALARI (ABD)','VI','VIR',850)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('WALLIS AND FUTUNA','WALLİS VE FUTUNA','WF','WLF',876)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('WESTERN SAHARA*','BATI SAHRA*','EH','ESH',732)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('YEMEN','YEMEN','YE','YEM',887)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ZAMBIA','ZAMBİYA','ZM','ZMB',894)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ZIMBABWE','ZİMBABVE','ZW','ZWE',716)
INSERT INTO EF_ULKE (ULKE_EN,ULKE_TR,ALPHA2,ALPHA3,NUMBER) VALUES('ÅLAND ISLANDS','ALAND ADALARI','AX','ALA',248)

SQL
OTOMATIK INSERT, sql

5Kas

Database deki Tüm Tablolara Otomatik Insert Oluşturma

Sql Server da bulunan database deki tüm tablolara otomatik insert komutu oluşturan script

bu script le database deki veri leri kopyalamak için kullanabilir

sorguyu geliştirerek devir gibi işlemlerde kullanabilirsiniz

Bu sorguda autoincrement tipindeki alanlara insert yapılamayacağım autoincrement alanlar tespit edilip kolon bilgilier için getirilmemiştir


-- Geçici bir tablo oluştur
CREATE TABLE #InsertCommands (
    TableName NVARCHAR(128),
    InsertCommand NVARCHAR(MAX)
)

DECLARE @KaynakDatabase NVARCHAR(128)
DECLARE @HedefDatabase NVARCHAR(128)
DECLARE @TableName NVARCHAR(128)
DECLARE @SQL NVARCHAR(MAX)

SET @KaynakDatabase = '[Verilerin Alınacağı Database]'
SET @HedefDatabase = '[Verilerin Kopyalacanağı Database]'

DECLARE tableCursor CURSOR FOR
SELECT t.name
FROM sys.tables t
WHERE t.type = 'U'

OPEN tableCursor

FETCH NEXT FROM tableCursor INTO @TableName

WHILE @@FETCH_STATUS = 0
BEGIN
    SET @SQL = 'INSERT INTO #InsertCommands (TableName, InsertCommand) SELECT ''' + @TableName + ''', 
                ''INSERT INTO ' + @HedefDatabase + '.[dbo].[' + @TableName + '] (' +
                STUFF((
                    SELECT ', [' + c.name + ']'
                    FROM sys.columns c
                    WHERE c.object_id = OBJECT_ID(@TableName) AND c.is_identity = 0
                    FOR XML PATH('')), 1, 2, '') + ') SELECT ' +
                STUFF((
                    SELECT ', [' + c.name + ']'
                    FROM sys.columns c
                    WHERE c.object_id = OBJECT_ID(@TableName) AND c.is_identity = 0
                    FOR XML PATH('')), 1, 2, '') + '   FROM ' + @KaynakDatabase + '.[dbo].' + '['+@TableName+']' + ''''

    EXEC sp_executesql @SQL

    FETCH NEXT FROM tableCursor INTO @TableName
END

CLOSE tableCursor
DEALLOCATE tableCursor

-- Geçici tablodaki sonuçları al
SELECT DISTINCT * FROM #InsertCommands  -- DISTINCT ile benzersiz sonuçlar alın

-- Geçici tabloyu temizle
DROP TABLE #InsertCommands

27Nis

SQL SERVER otomatik log dosyası küçültme

Sql server log dosyaları zamanla büyüyor ve sorun olmaya başlıyor

Bu log dosyalarını script ile küçültebileceğimiz gibi zamanlanmış iş (Job) ayarlıyarak da yapabiliriz

Script ile küçültmek için bu linke tıklayabilirsiniz https://ahmetaydinlik.com/2021/06/20/sql-server-log-dosyasi-kucultme-2/

Sql Server Menagment studio u açıyoruz

SQL server Agent servisi resimdeki gibi çalışıyor olmalıdır çalışmıyor ise SQL Server Configration Menagerden hizmeti başlatınız

SQL Server Agent e tıklıyoruz

Jobs a Sağ Tıklayıp New jobs diyoruz

General bölümünden İş adımızı ve açıklamamızı yazıyoruz

Steps bölümüne tıklıyoruz

New butonuna Tıklıyoruz

USE DatabesAdi 
ALTER DATABASE DatabesAdi SET RECOVERY SIMPLE WITH NO_WAIT  
DBCC SHRINKFILE([DatabesAdi_log], 0, TRUNCATEONLY)  
ALTER DATABASE DatabesAdi SET RECOVERY FULL WITH NO_WAIT  
GO

Yukarıdaki Scripti Database imize göre düzenliyoruz

Ok deyip bu bölümü kapatıyoruz

Schedules kısmına geliyoruz çalışma zamanlarını ayarlıyoruz New Butonuna basıyoruz

Zaman lama ayarlarımızı seçip ok diyoruz

Haftalı günlük aylık olacak şekilde küçültme işlemi yapabiliyoruz

Sql server Agent da Jobs ların altına yerleşti görevimiz

Test Etmek için

Oluşturduğumuz Job a Sağ tıklayıp Start Job at Steps diyoruz

yukarıdaki Succes yani işlem başarılı yı gördüğünüzde zamanlamalı iş tanımımız hazırdır ve planladığınız zaman da çalışır

2Mar

SQL Server Management Studio Server Kaydetme (Registered server)

SQL Server Management Studio sık kullandığınız uzak server var ise bunları register edip daha sonrasında hızlı bir şekilde bağlantı sağlayabiliriz

Connect olduğumuz server sağ tıklayarak register demeliyiz

Açılan Register Penceresinde Server ımıza isim verip kayıt ediyoruz

View Menüsünden Registered Servers Penceresini Açıyoruz

Database Engine Açtığımıza Local Server Groups altında Server ımızın kayıt olduğunu görüyoz

Kayıt ettiğimiz Server a Sağ Tıklayıp Object Explorer Tıkladığımızda Server Bağlantımız Otomatik Olarak Kurulacaktır

İsterseniz Local Server Groups altında yeni gruplar oluşturup serverlarınızı gruplayabilirsiniz

Delphi, SQL, Vcl
Oracle, Oracle Client

2Tem

Oracle Bağlantı Ayarları

Oracle Bağlantısını yapmak için Oracle Client Uygulamasını versiyona göre indiriyoruz

benim Kullanacağım Client 11g için dir

win64_11gR2_client

Client Uygulaması İndirdikten sonra içersindeki setup çalıştırıp

administrator seçip kuruluma devam edin

Kurulum bittikten sonra

Net Configrasyon Asistanı Çalıştıştırıp aşağıdaki adımlara göre devam ediyoruz

Aşağıdaki alan da Servis Adımızı giriyoruz

Standart post kullanıyorsanız portu değiştirmenize gerek yok farklı bir port kullanıyorsanız alttaki seçeneği seçerek manuel port girişi yapabilirsiniz

bu alana geldikten sonra bağlantı testi yapmak istediğimiz soruyor

change login diyerek kullanıcı bilgilerimiz giriyoruz

testiniz başarılı olduktan sonra client uygulamamız kuruldu

Başlat menüsünden sistem ortam değişkenleri açarak

Ortam Değişkenlerine giriyoruz

ORACLE_HOME değişkenini ekliyoruz değer olarak client uygulamasının yolunu gösteriyoruz

tnsname.ora dosyamızı düzenledikten sonra bağlantı sağlayabiliyoruz

AHMET AYDINLIK

Kategori arşivi: SQL

Bunu paylaş:

Bunu paylaş:

Bunu paylaş:

Bunu paylaş:

Bunu paylaş:

Bunu paylaş:

Bunu paylaş:

Bunu paylaş:

Bunu paylaş:

Bunu paylaş: