Blog Post by Murat Yaşar


Posted on Wednesday, June 26, 2019 8:33:37 AM and it has been read 306 times since then.


SQL Server Database table and ready script with color name information in English and Turkish

Hello,

This is not going to be a long blog post. I just want to share some sql script that might help you in case you need it in your work.

Let us assume we need a lookup table that will hold color names.

I created below script (T-SQL) in order to create a table and insert information into that table.

If you execute the below script a table will be created and color name information will be inserted. After that you can use this table of information in your projects.

I attached the script file as downloadable. You can find at the bottom of this page.

I hope it might be helpfull to some.

Have a great day.



CREATE TABLE [dbo].[ColorMap](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[NameTR] [nvarchar](150) COLLATE Latin1_General_CI_AS NOT NULL,
	[NameENG] [nvarchar](150) COLLATE Latin1_General_CI_AS NOT NULL,
	[DateCreated] [datetime2](7) NOT NULL,
	[IsActive] [bit] NOT NULL,
	[RGB] [nvarchar](8) COLLATE Latin1_General_CI_AS NULL
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[ColorMap] ON 

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (1, N'Alice Mavi', N'AliceBlue', CAST(N'2019-06-26T06:12:09.9800000' AS DateTime2), 1, N'F0F8FF')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (2, N'Antik Beyaz', N'AntiqueWhite', CAST(N'2019-06-26T06:12:22.5870000' AS DateTime2), 1, N'FAEBD7')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (3, N'Su rengi', N'Aqua', CAST(N'2019-06-26T06:12:26.5000000' AS DateTime2), 1, N'00FFFF')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (4, N'Akuamarin', N'Aquamarine', CAST(N'2019-06-26T06:12:30.2070000' AS DateTime2), 1, N'7FFFD4')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (5, N'Masmavi', N'Azure', CAST(N'2019-06-26T06:12:34.1870000' AS DateTime2), 1, N'F0FFFF')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (6, N'Bej', N'Beige', CAST(N'2019-06-26T06:12:38.0370000' AS DateTime2), 1, N'F5F5DC')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (7, N'Bisque', N'Bisque', CAST(N'2019-06-26T06:12:41.7130000' AS DateTime2), 1, N'FFE4C4')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (8, N'Siyah', N'Black', CAST(N'2019-06-26T06:12:45.3670000' AS DateTime2), 1, N'000000')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (9, N'Beyazlatılmış Badem', N'BlanchedAlmond', CAST(N'2019-06-26T06:12:48.9830000' AS DateTime2), 1, N'FFEBCD')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (10, N'Mavi', N'Blue', CAST(N'2019-06-26T06:12:53.8870000' AS DateTime2), 1, N'0000FF')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (11, N'Mavi menekşe', N'BlueViolet', CAST(N'2019-06-26T06:12:57.7800000' AS DateTime2), 1, N'8A2BE2')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (12, N'Kahverengi', N'Brown', CAST(N'2019-06-26T06:13:02.1170000' AS DateTime2), 1, N'A52A2A')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (13, N'BurlyWood', N'BurlyWood', CAST(N'2019-06-26T06:13:07.0300000' AS DateTime2), 1, N'DEB887')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (14, N'Öğrenci mavi', N'CadetBlue', CAST(N'2019-06-26T06:13:11.1170000' AS DateTime2), 1, N'5F9EA0')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (15, N'Chartreuse yeşil', N'Chartreuse', CAST(N'2019-06-26T06:13:17.3200000' AS DateTime2), 1, N'7FFF00')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (16, N'Çikolata', N'Chocolate', CAST(N'2019-06-26T06:13:21.4530000' AS DateTime2), 1, N'D2691E')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (17, N'Mercan', N'Coral', CAST(N'2019-06-26T06:13:27.7900000' AS DateTime2), 1, N'FF7F50')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (18, N'Peygamber Çiçeği Mavisi', N'CornflowerBlue', CAST(N'2019-06-26T06:13:32.2170000' AS DateTime2), 1, N'6495ED')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (19, N'Mısır püskülü', N'Cornsilk', CAST(N'2019-06-26T06:13:35.4700000' AS DateTime2), 1, N'FFF8DC')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (20, N'Kıpkırmızı', N'Crimson', CAST(N'2019-06-26T06:13:39.6530000' AS DateTime2), 1, N'DC143C')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (21, N'Camgöbeği', N'Cyan', CAST(N'2019-06-26T06:13:42.7400000' AS DateTime2), 1, N'00FFFF')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (22, N'Koyu mavi', N'DarkBlue', CAST(N'2019-06-26T06:13:46.0430000' AS DateTime2), 1, N'00008B')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (23, N'Koyu camgöbeği', N'DarkCyan', CAST(N'2019-06-26T06:13:48.8000000' AS DateTime2), 1, N'008B8B')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (24, N'Koyu Altın Başak', N'DarkGoldenrod', CAST(N'2019-06-26T06:13:51.8100000' AS DateTime2), 1, N'B8860B')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (25, N'Koyu gri', N'DarkGray', CAST(N'2019-06-26T06:13:54.9970000' AS DateTime2), 1, N'A9A9A9')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (26, N'Koyu yeşil', N'DarkGreen', CAST(N'2019-06-26T06:13:58.2200000' AS DateTime2), 1, N'006400')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (27, N'Kara haki', N'DarkKhaki', CAST(N'2019-06-26T06:14:03.6470000' AS DateTime2), 1, N'BDB76B')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (28, N'Koyu eflatun', N'DarkMagenta', CAST(N'2019-06-26T06:14:06.9370000' AS DateTime2), 1, N'8B008B')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (29, N'Koyu Zeytin Yeşili', N'DarkOliveGreen', CAST(N'2019-06-26T06:14:09.8900000' AS DateTime2), 1, N'556B2F')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (30, N'Koyu turuncu', N'DarkOrange', CAST(N'2019-06-26T06:14:12.9230000' AS DateTime2), 1, N'FF8C00')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (31, N'Koyu orkide', N'DarkOrchid', CAST(N'2019-06-26T06:14:18.1800000' AS DateTime2), 1, N'9932CC')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (32, N'Koyu kırmızı', N'DarkRed', CAST(N'2019-06-26T06:14:21.2500000' AS DateTime2), 1, N'8B0000')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (33, N'Koyu yavruağzı', N'DarkSalmon', CAST(N'2019-06-26T06:14:24.3030000' AS DateTime2), 1, N'E9967A')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (34, N'Koyu deniz yeşili', N'DarkSeaGreen', CAST(N'2019-06-26T06:14:27.7100000' AS DateTime2), 1, N'8FBC8F')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (35, N'Koyu kayrak mavisi', N'DarkSlateBlue', CAST(N'2019-06-26T06:14:32.6000000' AS DateTime2), 1, N'483D8B')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (36, N'Koyu kayrak gri', N'DarkSlateGray', CAST(N'2019-06-26T06:14:36.8600000' AS DateTime2), 1, N'2F4F4F')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (37, N'Koyu Turkuaz', N'DarkTurquoise', CAST(N'2019-06-26T06:14:41.3970000' AS DateTime2), 1, N'00CED1')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (38, N'Koyu mor', N'DarkViolet', CAST(N'2019-06-26T06:14:46.4830000' AS DateTime2), 1, N'9400D3')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (39, N'Derin pembe', N'DeepPink', CAST(N'2019-06-26T06:14:50.9470000' AS DateTime2), 1, N'FF1493')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (40, N'Derin gök mavisi', N'DeepSkyBlue', CAST(N'2019-06-26T06:14:55.1270000' AS DateTime2), 1, N'00BFFF')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (41, N'Loş gri', N'DimGray', CAST(N'2019-06-26T06:14:59.1200000' AS DateTime2), 1, N'696969')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (42, N'Atlatan mavi', N'DodgerBlue', CAST(N'2019-06-26T06:15:03.5300000' AS DateTime2), 1, N'1E90FF')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (43, N'Ateş tuğlası', N'FireBrick', CAST(N'2019-06-26T06:15:07.5930000' AS DateTime2), 1, N'B22222')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (44, N'Çiçek beyaz', N'FloralWhite', CAST(N'2019-06-26T06:15:11.5370000' AS DateTime2), 1, N'FFFAF0')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (45, N'Orman yeşili', N'ForestGreen', CAST(N'2019-06-26T06:15:15.2830000' AS DateTime2), 1, N'228B22')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (46, N'Fuşya', N'Fuchsia', CAST(N'2019-06-26T06:15:19.3230000' AS DateTime2), 1, N'FF00FF')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (47, N'Gainsboro', N'Gainsboro', CAST(N'2019-06-26T06:15:22.5600000' AS DateTime2), 1, N'DCDCDC')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (48, N'Hayalet beyazı', N'GhostWhite', CAST(N'2019-06-26T06:15:27.3300000' AS DateTime2), 1, N'F8F8FF')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (49, N'Altın', N'Gold', CAST(N'2019-06-26T06:15:30.9370000' AS DateTime2), 1, N'FFD700')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (50, N'Altın kırmızısı', N'Goldenrod', CAST(N'2019-06-26T06:15:38.6470000' AS DateTime2), 1, N'DAA520')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (51, N'Gri', N'Gray', CAST(N'2019-06-26T06:15:44.4130000' AS DateTime2), 1, N'BEBEBE')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (52, N'Yeşil', N'Green', CAST(N'2019-06-26T06:15:49.1700000' AS DateTime2), 1, N'008000')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (53, N'Yeşil sarı', N'GreenYellow', CAST(N'2019-06-26T06:16:01.7770000' AS DateTime2), 1, N'ADFF2F')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (54, N'Tatlı özsu', N'Honeydew', CAST(N'2019-06-26T06:16:05.4870000' AS DateTime2), 1, N'F0FFF0')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (55, N'Sıcak pembe', N'HotPink', CAST(N'2019-06-26T06:16:09.2830000' AS DateTime2), 1, N'FF69B4')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (56, N'Hint kırmızısı', N'IndianRed', CAST(N'2019-06-26T06:16:12.8430000' AS DateTime2), 1, N'CD5C5C')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (57, N'Çivit', N'Indigo', CAST(N'2019-06-26T06:16:16.1470000' AS DateTime2), 1, N'4B0082')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (58, N'Fildişi', N'Ivory', CAST(N'2019-06-26T06:16:19.8270000' AS DateTime2), 1, N'FFFFF0')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (59, N'Haki', N'Khaki', CAST(N'2019-06-26T06:16:25.1570000' AS DateTime2), 1, N'F0E68C')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (60, N'Lavanta', N'Lavender', CAST(N'2019-06-26T06:16:28.3600000' AS DateTime2), 1, N'E6E6FA')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (61, N'Lavanta allık', N'LavenderBlush', CAST(N'2019-06-26T06:16:31.8630000' AS DateTime2), 1, N'FFF0F5')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (62, N'Çim yeşili', N'LawnGreen', CAST(N'2019-06-26T06:16:35.2100000' AS DateTime2), 1, N'7CFC00')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (63, N'Limon şifon', N'LemonChiffon', CAST(N'2019-06-26T06:16:40.9130000' AS DateTime2), 1, N'FFFACD')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (64, N'Açık mavi', N'LightBlue', CAST(N'2019-06-26T06:16:46.0370000' AS DateTime2), 1, N'ADD8E6')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (65, N'Açık mercan', N'LightCoral', CAST(N'2019-06-26T06:16:50.5300000' AS DateTime2), 1, N'F08080')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (66, N'Açık cam göbeği', N'LightCyan', CAST(N'2019-06-26T06:16:54.8200000' AS DateTime2), 1, N'E0FFFF')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (67, N'Açık altın başak sarı', N'LightGoldenrodYellow', CAST(N'2019-06-26T06:16:58.4130000' AS DateTime2), 1, N'FAFAD2')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (68, N'Açık yeşil', N'LightGreen', CAST(N'2019-06-26T06:17:02.2470000' AS DateTime2), 1, N'90EE90')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (69, N'Açık gri', N'LightGrey', CAST(N'2019-06-26T06:17:05.9300000' AS DateTime2), 1, N'D3D3D3')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (70, N'Açık pembe', N'LightPink', CAST(N'2019-06-26T06:17:09.7600000' AS DateTime2), 1, N'FFB6C1')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (71, N'Açık yavru ağzı', N'LightSalmon', CAST(N'2019-06-26T06:17:13.9670000' AS DateTime2), 1, N'FFA07A')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (72, N'Açık deniz yeşili', N'LightSeaGreen', CAST(N'2019-06-26T06:17:17.3230000' AS DateTime2), 1, N'20B2AA')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (73, N'Açık gökyüzü mavisi', N'LightSkyBlue', CAST(N'2019-06-26T06:17:21.0600000' AS DateTime2), 1, N'87CEFA')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (74, N'Açık kayrak grisi', N'LightSlateGray', CAST(N'2019-06-26T06:17:24.6300000' AS DateTime2), 1, N'778899')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (75, N'Açık çelik mavisi', N'LightSteelBlue', CAST(N'2019-06-26T06:17:28.9170000' AS DateTime2), 1, N'B0C4DE')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (76, N'Açık sarı', N'LightYellow', CAST(N'2019-06-26T06:17:33.1070000' AS DateTime2), 1, N'FFFFE0')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (77, N'Misket limonu', N'Lime', CAST(N'2019-06-26T06:17:37.4100000' AS DateTime2), 1, N'00FF00')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (78, N'Limon yeşili', N'LimeGreen', CAST(N'2019-06-26T06:17:41.7470000' AS DateTime2), 1, N'32CD32')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (79, N'Keten', N'Linen', CAST(N'2019-06-26T06:17:47.0830000' AS DateTime2), 1, N'FAF0E6')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (80, N'Eflatun', N'Magenta', CAST(N'2019-06-26T06:17:52.2400000' AS DateTime2), 1, N'FF00FF')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (81, N'Kestane rengi', N'Maroon', CAST(N'2019-06-26T06:17:56.1470000' AS DateTime2), 1, N'800000')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (82, N'Orta Akuamarin', N'MediumAquamarine', CAST(N'2019-06-26T06:18:00.4530000' AS DateTime2), 1, N'66CDAA')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (83, N'Orta mavi', N'MediumBlue', CAST(N'2019-06-26T06:18:06.1730000' AS DateTime2), 1, N'0000CD')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (84, N'Orta orkide', N'MediumOrchid', CAST(N'2019-06-26T06:18:09.8930000' AS DateTime2), 1, N'BA55D3')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (85, N'Orta mor', N'MediumPurple', CAST(N'2019-06-26T06:18:13.6000000' AS DateTime2), 1, N'9370DB')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (86, N'Orta deniz yeşili', N'MediumSeaGreen', CAST(N'2019-06-26T06:18:17.7800000' AS DateTime2), 1, N'3CB371')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (87, N'Orta kayrak mavi', N'MediumSlateBlue', CAST(N'2019-06-26T06:18:22.0730000' AS DateTime2), 1, N'7B68EE')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (88, N'Orta turkuaz', N'MediumTurquoise', CAST(N'2019-06-26T06:18:51.3770000' AS DateTime2), 1, N'48D1CC')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (89, N'Orta menekşe kırmızı', N'MediumVioletRed', CAST(N'2019-06-26T06:18:56.3900000' AS DateTime2), 1, N'C71585')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (90, N'Gece yarısı mavisi', N'MidnightBlue', CAST(N'2019-06-26T06:19:00.3930000' AS DateTime2), 1, N'191970')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (91, N'Nane kreması', N'MintCream', CAST(N'2019-06-26T06:19:04.1400000' AS DateTime2), 1, N'F5FFFA')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (92, N'Misty Rose', N'MistyRose', CAST(N'2019-06-26T06:19:08.2200000' AS DateTime2), 1, N'FFE4E1')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (93, N'Mokasen', N'Moccasin', CAST(N'2019-06-26T06:19:12.8900000' AS DateTime2), 1, N'FFE4B5')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (94, N'Navajo Beyaz', N'NavajoWhite', CAST(N'2019-06-26T06:19:17.1900000' AS DateTime2), 1, N'FFDEAD')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (95, N'Lacivert', N'Navy', CAST(N'2019-06-26T06:19:21.3500000' AS DateTime2), 1, N'000080')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (96, N'Eski dantel', N'OldLace', CAST(N'2019-06-26T06:19:25.3830000' AS DateTime2), 1, N'FDF5E6')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (97, N'Zeytin', N'Olive', CAST(N'2019-06-26T06:19:29.0500000' AS DateTime2), 1, N'808000')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (98, N'Zeytin yeşili', N'OliveDrab', CAST(N'2019-06-26T06:19:33.1770000' AS DateTime2), 1, N'6B8E23')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (99, N'Portakal', N'Orange', CAST(N'2019-06-26T06:19:36.9170000' AS DateTime2), 1, N'FFA500')

GO

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (100, N'Turuncu kırmızı', N'OrangeRed', CAST(N'2019-06-26T06:19:40.4430000' AS DateTime2), 1, N'FF4500')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (101, N'Orkide', N'Orchid', CAST(N'2019-06-26T06:19:44.0830000' AS DateTime2), 1, N'DA70D6')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (102, N'Soluk altın çubuk', N'PaleGoldenrod', CAST(N'2019-06-26T06:19:47.5030000' AS DateTime2), 1, N'EEE8AA')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (103, N'Soluk yeşil', N'PaleGreen', CAST(N'2019-06-26T06:19:51.1630000' AS DateTime2), 1, N'98FB98')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (104, N'Soluk turkuaz', N'PaleTurquoise', CAST(N'2019-06-26T06:19:54.8030000' AS DateTime2), 1, N'AFEEEE')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (105, N'Soluk menekşe kırmızı', N'PaleVioletRed', CAST(N'2019-06-26T06:19:59.1400000' AS DateTime2), 1, N'DB7093')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (106, N'Papaya Kırbaç', N'PapayaWhip', CAST(N'2019-06-26T06:20:04.0730000' AS DateTime2), 1, N'FFEFD5')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (107, N'Şeftali Puf', N'PeachPuff', CAST(N'2019-06-26T06:20:08.7630000' AS DateTime2), 1, N'FFDAB9')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (108, N'Peru', N'Peru', CAST(N'2019-06-26T06:20:12.7700000' AS DateTime2), 1, N'CD853F')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (109, N'Pembe', N'Pink', CAST(N'2019-06-26T06:20:16.1100000' AS DateTime2), 1, N'FFC0CB')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (110, N'Erik', N'Plum', CAST(N'2019-06-26T06:20:19.3170000' AS DateTime2), 1, N'DDA0DD')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (111, N'Toz mavi', N'PowderBlue', CAST(N'2019-06-26T06:20:23.4500000' AS DateTime2), 1, N'B0E0E6')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (112, N'Mor', N'Purple', CAST(N'2019-06-26T06:20:30.1170000' AS DateTime2), 1, N'A020F0')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (113, N'Kırmızı', N'Red', CAST(N'2019-06-26T06:20:33.6330000' AS DateTime2), 1, N'FF0000')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (114, N'Pembe kahverengi', N'RosyBrown', CAST(N'2019-06-26T06:20:37.2070000' AS DateTime2), 1, N'BC8F8F')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (115, N'Kraliyet mavisi', N'RoyalBlue', CAST(N'2019-06-26T06:20:46.6070000' AS DateTime2), 1, N'4169E1')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (116, N'Eyer kahverengi', N'SaddleBrown', CAST(N'2019-06-26T06:20:49.9370000' AS DateTime2), 1, N'8B4513')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (117, N'Yavru ağzı', N'Salmon', CAST(N'2019-06-26T06:20:53.4600000' AS DateTime2), 1, N'FA8072')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (118, N'Kumlu kahverengi', N'SandyBrown', CAST(N'2019-06-26T06:20:56.5700000' AS DateTime2), 1, N'F4A460')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (119, N'Deniz yeşili', N'SeaGreen', CAST(N'2019-06-26T06:21:00.0830000' AS DateTime2), 1, N'2E8B57')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (120, N'Deniz kabuğu', N'Seashell', CAST(N'2019-06-26T06:21:04.3200000' AS DateTime2), 1, N'FFF5EE')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (121, N'Koyu kahverengi', N'Sienna', CAST(N'2019-06-26T06:21:08.9770000' AS DateTime2), 1, N'A0522D')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (122, N'Gümüş', N'Silver', CAST(N'2019-06-26T06:21:12.5100000' AS DateTime2), 1, N'C0C0C0')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (123, N'Gökyüzü mavi', N'SkyBlue', CAST(N'2019-06-26T06:21:15.7130000' AS DateTime2), 1, N'87CEEB')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (124, N'Kayrak mavisi', N'SlateBlue', CAST(N'2019-06-26T06:21:19.8630000' AS DateTime2), 1, N'6A5ACD')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (125, N'Kayrak gri', N'SlateGray', CAST(N'2019-06-26T06:21:23.7700000' AS DateTime2), 1, N'708090')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (126, N'Kar', N'Snow', CAST(N'2019-06-26T06:21:29.3770000' AS DateTime2), 1, N'FFFAFA')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (127, N'İlkbahar yeşili', N'SpringGreen', CAST(N'2019-06-26T06:21:32.5700000' AS DateTime2), 1, N'00FF7F')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (128, N'Çelik mavisi', N'SteelBlue', CAST(N'2019-06-26T06:21:36.2130000' AS DateTime2), 1, N'4682B4')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (129, N'Tan', N'Tan', CAST(N'2019-06-26T06:21:39.4530000' AS DateTime2), 1, N'D2B48C')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (130, N'Petrol yeşili, ördekbaşı', N'Teal', CAST(N'2019-06-26T06:21:43.9470000' AS DateTime2), 1, N'008080')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (131, N'Devedikeni', N'Thistle', CAST(N'2019-06-26T06:21:48.0600000' AS DateTime2), 1, N'D8BFD8')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (132, N'Domates', N'Tomato', CAST(N'2019-06-26T06:21:53.3830000' AS DateTime2), 1, N'FF6347')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (133, N'Turkuaz', N'Turquoise', CAST(N'2019-06-26T06:21:57.8370000' AS DateTime2), 1, N'40E0D0')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (134, N'Menekşe', N'Violet', CAST(N'2019-06-26T06:22:02.3830000' AS DateTime2), 1, N'EE82EE')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (135, N'Buğday', N'Wheat', CAST(N'2019-06-26T06:22:06.4500000' AS DateTime2), 1, N'F5DEB3')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (136, N'Beyaz', N'White', CAST(N'2019-06-26T06:22:10.2100000' AS DateTime2), 1, N'FFFFFF')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (137, N'Beyaz duman', N'WhiteSmoke', CAST(N'2019-06-26T06:22:13.4500000' AS DateTime2), 1, N'F5F5F5')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (138, N'Sarı', N'Yellow', CAST(N'2019-06-26T06:22:17.2700000' AS DateTime2), 1, N'FFFF00')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (139, N'Sarı yeşil', N'YellowGreen', CAST(N'2019-06-26T06:44:16.0170000' AS DateTime2), 1, N'9ACD32')

INSERT [dbo].[ColorMap] ([Id], [NameTR], [NameENG], [DateCreated], [IsActive], [RGB]) 
VALUES (140, N'Orta Bahar Yeşili', N'MediumSpringGreen', CAST(N'2019-06-26T06:44:33.3470000' AS DateTime2), 1, N'00FA9A')

SET IDENTITY_INSERT [dbo].[ColorMap] OFF

/BlogEntryImages/151/Capture.PNG


- Downloadable File/s -
File Name File Size Description
script.txt 55.027 KB Script file to create table and insert information into table Download

(In order to use this feature, you have to register.)

Tag Related Blog Entries

Creating a Count Widget that uses Hana DB as a data source and displaying it in SAP Business One Cockpit

Thursday, April 11, 2019 1   563  

Creating a Crystal Report that uses Hana as a data source and importing this report into SAP Business One

Saturday, January 19, 2019 1   941  

Countries Android Mobile Application

Saturday, April 23, 2016 0   1863  

Compare Tables Row By Row in PostgreSQL

Sunday, June 21, 2015 2   9727  

Some Helpful Links For Software Developers

Saturday, April 28, 2012 0   5469  

Populate Nested TreeView In Asp.Net Using Common Table Expression In SQL Server

Sunday, May 01, 2011 0   6051   5

LINQ

Friday, October 08, 2010 0   2096  

PostgreSQL 8.4.4 Data Types

Monday, September 27, 2010 0   1767  

Tuning, Optimizing, Increasing and Improving Performance of Asp.Net Application - Part III

Saturday, January 23, 2010 0   2632