City MSSQL - Türkiye İlleri MSSQL Sorgusu

city.sql

USE [databaseName]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[City](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](20) NOT NULL,
	[IsActive] [bit] NOT NULL,
 CONSTRAINT [PK_City] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
***************************************

USE [databaseName]
GO
SET IDENTITY_INSERT [dbo].[City] ON

INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (1,'ADANA',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (2,'ADIYAMAN',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (3,'AFYONKARAHİSAR',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (4,'AĞRI',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (5,'AKSARAY',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (6,'AMASYA',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (7,'ANKARA',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (8,'ANTALYA',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (9,'ARDAHAN',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (10,'ARTVİN',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (11,'AYDIN',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (12,'BALIKESİR',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (13,'BARTIN',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (14,'BATMAN',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (15,'BAYBURT',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (16,'BİLECİK',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (17,'BİNGÖL',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (18,'BİTLİS',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (19,'BOLU',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (20,'BURDUR',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (21,'BURSA',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (22,'ÇANAKKALE',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (23,'ÇANKIRI',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (24,'ÇORUM',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (25,'DENİZLİ',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (26,'DİYARBAKIR',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (27,'DÜZCE',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (28,'EDİRNE',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (29,'ELAZIĞ',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (30,'ERZİNCAN',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (31,'ERZURUM',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (32,'ESKİŞEHİR',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (33,'GAZİANTEP',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (34,'GİRESUN',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (35,'GÜMÜŞHANE',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (36,'HAKKARİ',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (37,'HATAY',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (38,'IĞDIR',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (39,'ISPARTA',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (40,'İSTANBUL',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (41,'İZMİR',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (42,'KAHRAMANMARAŞ',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (43,'KARABÜK',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (44,'KARAMAN',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (45,'KARS',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (46,'KASTAMONU',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (47,'KAYSERİ',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (48,'KIRIKKALE',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (49,'KIRKLARELİ',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (50,'KIRŞEHİR',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (51,'KİLİS',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (52,'KOCAELİ',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (53,'KONYA',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (54,'KÜTAHYA',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (55,'MALATYA',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (56,'MANİSA',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (57,'MARDİN',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (58,'MERSİN',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (59,'MUĞLA',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (60,'MUŞ',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (61,'NEVŞEHİR',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (62,'NİĞDE',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (63,'ORDU',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (64,'OSMANİYE',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (65,'RİZE',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (66,'SAKARYA',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (67,'SAMSUN',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (68,'SİİRT',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (69,'SİNOP',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (70,'SİVAS',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (71,'ŞANLIURFA',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (72,'ŞIRNAK',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (73,'TEKİRDAĞ',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (74,'TOKAT',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (75,'TRABZON',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (76,'TUNCELİ',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (77,'UŞAK',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (78,'VAN',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (79,'YALOVA',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (80,'YOZGAT',1)
INSERT INTO [dbo].[City] (Id,[Name],[IsActive]) VALUES (81,'ZONGULDAK',1)

SET IDENTITY_INSERT [dbo].[City] OFF
GO