AHMET AYDINLIK – Yazılım Notlarının Yer Aldığı Bireysel Blog

Html, JavaScript, web
html, js, JS TO PRINT, print, TABLE TO PRINT, TABLO DAN YAZDIRMA

27Mar

Js Tablo yazdırma Scripti

Html Sayfalarda bir tablo id ile tetiklendiğinde tablo içeriğini yazdırmaya aktaran script

<script>
function PrintTable(tabloId) {
    let table = document.querySelector(tabloId);
    if (!table) {
        console.error("Tablo bulunamadı: " + tabloId);
        return;
    }
 
    let printWindow = window.open('', '', 'width=800,height=600');
    printWindow.document.write('<html><head><title>Tablo Yazdır</title>');
    printWindow.document.write('<style>');
    printWindow.document.write('table { border-collapse: collapse; width: 100%; }');
    printWindow.document.write('th, td { border: 1px solid black; padding: 8px; text-align: left; }');
    printWindow.document.write('</style></head><body>');
     
    printWindow.document.write(table.outerHTML); // Sadece tablonun içeriğini ekler
    printWindow.document.write('</body></html>');
     
    printWindow.document.close();
    printWindow.print();
}
</script>

Örnek Kullanımı

1	`<button` `onclick="PrintTable('#Tablo1')">Yazdır</button>`

Html, JavaScript, web
html, js, JS TO PDF, PDF, TABLE TO PDF, TABLO DAN PDF E AKTARIM

27Mar

Js Tablodan Pdf Aktarım Scripti

Html Sayfalarda bir tablo id ile tetiklendiğinde tablo içeriğini pdf aktaran script

<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/2.5.1/jspdf.umd.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf-autotable/3.5.27/jspdf.plugin.autotable.min.js"></script>
 
<script>
 
 
function TabloPDF(tabloId, dosyaAdi = "tablo.pdf") {
    let table = document.querySelector(tabloId);
    if (!table) {
        console.error("Tablo bulunamadı: " + tabloId);
        return;
    }
 
    let { jsPDF } = window.jspdf;
    let doc = new jsPDF();
      doc.addFont('font/roboto.ttf', 'Roboto', 'normal');
  doc.setFont("Roboto", "normal");
  
 ;
    doc.autoTable({
        html: table ,
        styles: {
            font: "Roboto", // Alternatif: "times"
            fontStyle: "normal"
        }
    });
 
    doc.save(dosyaAdi);
}
</script>

Örnek Kullanımı

1	`<button onclick="TabloPDF('#Tablo1')">PDF İndir</button>`

Html, JavaScript, web
excel, html to excel, js, js excel

27Mar

Js Tablodan Excel Aktarım Scripti

Html Sayfalarda bir tablo id ile tetiklendiğinde tablo içeriğini excele aktaran script

<script src="https://cdnjs.cloudflare.com/ajax/libs/xlsx/0.18.5/xlsx.full.min.js"></script>
<script>
function TabloExcel(tabloId, dosyaAdi = "tablo.xlsx") {
    let table = document.querySelector(tabloId);
    if (!table) {
        console.error("Tablo bulunamadı: " + tabloId);
        return;
    }
 
    let wb = XLSX.utils.book_new();
    let ws = XLSX.utils.table_to_sheet(table);
    XLSX.utils.book_append_sheet(wb, ws, "Sayfa1");
 
    XLSX.writeFile(wb, dosyaAdi);
}
</script>

örnek Kullanımı

1	`<button` `onclick="TabloExcel('#Tablo1')">Excel İndir</button>`

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

001

002

003

004

005

006

007

008

009

010

011

012

013

014

015

016

017

018

019

020

021

022

023

024

025

026

027

028

029

030

031

032

033

034

035

036

037

038

039

040

041

042

043

044

045

046

047

048

049

050

051

052

053

054

055

056

057

058

059

060

061

062

063

064

065

066

067

068

069

070

071

072

073

074

075

076

077

078

079

080

081

082

083

084

085

086

087

088

089

090

091

092

093

094

095

096

097

098

099

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

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

Delphi, Vcl
delphi, delphi json, delphi json okuma, JSON

11Eyl

Delphi Json veri Alma

Qr-code lar da oluşan verileri okumak için aşağıdaki kodlar yardımcı olacaktır

aşağıdaki örnek bir e-irsaliye de bulunan qr-code verisinin içindeki almak için örneklendirilmiştir

uses System.JSON;
 
procedure TForm3.Button1Click(Sender: TObject);
var
  jsonData: TJSONObject;
begin
  // JSON veriyi bir TJSONObject nesnesine çözümle
  jsonData := TJSONObject.ParseJSONValue(Memo1.Lines.Text) as TJSONObject;
 
  if Assigned(jsonData) then
  begin
    try
      // ettn değerini al
      edit1.Text := jsonData.GetValue('ettn').Value;
      edit2.Text := jsonData.GetValue('vkntckn').Value;
      edit3.Text := jsonData.GetValue('avkntckn').Value;
      edit4.Text := jsonData.GetValue('senaryo').Value;
      edit5.Text := jsonData.GetValue('tip').Value;
      edit6.Text := jsonData.GetValue('tarih').Value;
      edit7.Text := jsonData.GetValue('no').Value;
      edit8.Text := jsonData.GetValue('sevktarihi').Value;
      edit9.Text := jsonData.GetValue('sevkzamani').Value;
      edit10.Text := jsonData.GetValue('tasiyicivkn').Value;
      edit11.Text := jsonData.GetValue('plaka').Value;
 
 
    finally
      jsonData.Free;
    end;
  end
  else
  begin
    ShowMessage('JSON Verisi Çözümlenemedi.');
  end;
end;

Örnek Programı İndirmek için aşağıdaki bağlantıyı kullanınız

Kaynak Kodları İndir