Posted on Wednesday, June 26, 2019 8:33:37 AM and it has been read 4267 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
- Downloadable File/s - |
|||
---|---|---|---|
File Name | File Size | Description | |
script.txt | 55.027 KB | Script file to create table and insert information into table | Download |
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 3163 |
Creating a Crystal Report that uses Hana as a data source and importing this report into SAP Business One
Saturday, January 19, 2019 1 3444 |
Countries Android Mobile Application
Saturday, April 23, 2016 0 3570 |
Compare Tables Row By Row in PostgreSQL
Sunday, June 21, 2015 2 13841 |
Some Helpful Links For Software Developers
Saturday, April 28, 2012 0 7817 |
Populate Nested TreeView In Asp.Net Using Common Table Expression In SQL Server
Sunday, May 01, 2011 0 8407 5 |
LINQ
Friday, October 08, 2010 0 3298 |
PostgreSQL 8.4.4 Data Types
Monday, September 27, 2010 0 2640 |
Tuning, Optimizing, Increasing and Improving Performance of Asp.Net Application - Part III
Saturday, January 23, 2010 0 4125 |