Search This Blog

2009-07-09

how-to create an html color table in sql server 2008



USE [GenApp]
GO
 
/****** Object:  Table [dbo].[Color]    Script Date: 07/09/2009 11:59:06 ******/
SET ANSI_NULLS ON
GO
 
SET QUOTED_IDENTIFIER ON
GO
 
SET ANSI_PADDING ON
GO
 
CREATE TABLE [dbo].[Color](
[ColorId] [int] IDENTITY(1,1) NOT NULL,
[ColorName] [varchar](50) NULL,
[ColorHex] [nchar](7) NULL,
[ColorDescription] [varchar](200) NULL,
CONSTRAINT [PK_Color] PRIMARY KEY CLUSTERED 
(
[ColorId] 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
 
SET ANSI_PADDING ON
GO
 
 
USE [GenApp];
SET NOCOUNT ON;
SET XACT_ABORT ON;
GO
 
SET IDENTITY_INSERT [dbo].[Color] ON;
BEGIN TRANSACTION;
INSERT INTO [dbo].[Color]([ColorId], [ColorName], [ColorHex], [ColorDescription])
SELECT 1, N'Black ', N'#000000', NULL UNION ALL
SELECT 2, N'Navy ', N'#000080', NULL UNION ALL
SELECT 3, N'DarkBlue ', N'#00008B', NULL UNION ALL
SELECT 4, N'MediumBlue ', N'#0000CD', NULL UNION ALL
SELECT 5, N'Blue ', N'#0000FF', NULL UNION ALL
SELECT 6, N'DarkGreen ', N'#006400', NULL UNION ALL
SELECT 7, N'Green ', N'#008000', NULL UNION ALL
SELECT 8, N'Teal ', N'#008080', NULL UNION ALL
SELECT 9, N'DarkCyan ', N'#008B8B', NULL UNION ALL
SELECT 10, N'DeepSkyBlue ', N'#00BFFF', NULL UNION ALL
SELECT 11, N'DarkTurquoise ', N'#00CED1', NULL UNION ALL
SELECT 12, N'MediumSpringGreen ', N'#00FA9A', NULL UNION ALL
SELECT 13, N'Lime ', N'#00FF00', NULL UNION ALL
SELECT 14, N'SpringGreen ', N'#00FF7F', NULL UNION ALL
SELECT 15, N'Aqua ', N'#00FFFF', NULL UNION ALL
SELECT 16, N'Cyan ', N'#00FFFF', NULL UNION ALL
SELECT 17, N'MidnightBlue ', N'#191970', NULL UNION ALL
SELECT 18, N'DodgerBlue ', N'#1E90FF', NULL UNION ALL
SELECT 19, N'LightSeaGreen ', N'#20B2AA', NULL UNION ALL
SELECT 20, N'ForestGreen ', N'#228B22', NULL UNION ALL
SELECT 21, N'SeaGreen ', N'#2E8B57', NULL UNION ALL
SELECT 22, N'DarkSlateGray ', N'#2F4F4F', NULL UNION ALL
SELECT 23, N'LimeGreen ', N'#32CD32', NULL UNION ALL
SELECT 24, N'MediumSeaGreen ', N'#3CB371', NULL UNION ALL
SELECT 25, N'Turquoise ', N'#40E0D0', NULL UNION ALL
SELECT 26, N'RoyalBlue ', N'#4169E1', NULL UNION ALL
SELECT 27, N'SteelBlue ', N'#4682B4', NULL UNION ALL
SELECT 28, N'DarkSlateBlue ', N'#483D8B', NULL UNION ALL
SELECT 29, N'MediumTurquoise ', N'#48D1CC', NULL UNION ALL
SELECT 30, N'Indigo  ', N'#4B0082', NULL UNION ALL
SELECT 31, N'DarkOliveGreen ', N'#556B2F', NULL UNION ALL
SELECT 32, N'CadetBlue ', N'#5F9EA0', NULL UNION ALL
SELECT 33, N'CornflowerBlue ', N'#6495ED', NULL UNION ALL
SELECT 34, N'MediumAquaMarine ', N'#66CDAA', NULL UNION ALL
SELECT 35, N'DimGray ', N'#696969', NULL UNION ALL
SELECT 36, N'SlateBlue ', N'#6A5ACD', NULL UNION ALL
SELECT 37, N'OliveDrab ', N'#6B8E23', NULL UNION ALL
SELECT 38, N'SlateGray ', N'#708090', NULL UNION ALL
SELECT 39, N'LightSlateGray ', N'#778899', NULL UNION ALL
SELECT 40, N'MediumSlateBlue ', N'#7B68EE', NULL UNION ALL
SELECT 41, N'LawnGreen ', N'#7CFC00', NULL UNION ALL
SELECT 42, N'Chartreuse ', N'#7FFF00', NULL UNION ALL
SELECT 43, N'Aquamarine ', N'#7FFFD4', NULL UNION ALL
SELECT 44, N'Maroon ', N'#800000', NULL UNION ALL
SELECT 45, N'Purple ', N'#800080', NULL UNION ALL
SELECT 46, N'Olive ', N'#808000', NULL UNION ALL
SELECT 47, N'Gray ', N'#808080', NULL UNION ALL
SELECT 48, N'SkyBlue ', N'#87CEEB', NULL UNION ALL
SELECT 49, N'LightSkyBlue ', N'#87CEFA', NULL UNION ALL
SELECT 50, N'BlueViolet ', N'#8A2BE2', NULL
COMMIT;
RAISERROR (N'[dbo].[Color]: Insert Batch: 1.....Done!', 10, 1) WITH NOWAIT;
GO
 
BEGIN TRANSACTION;
INSERT INTO [dbo].[Color]([ColorId], [ColorName], [ColorHex], [ColorDescription])
SELECT 51, N'DarkRed ', N'#8B0000', NULL UNION ALL
SELECT 52, N'DarkMagenta ', N'#8B008B', NULL UNION ALL
SELECT 53, N'SaddleBrown ', N'#8B4513', NULL UNION ALL
SELECT 54, N'DarkSeaGreen ', N'#8FBC8F', NULL UNION ALL
SELECT 55, N'LightGreen ', N'#90EE90', NULL UNION ALL
SELECT 56, N'MediumPurple ', N'#9370D8', NULL UNION ALL
SELECT 57, N'DarkViolet ', N'#9400D3', NULL UNION ALL
SELECT 58, N'PaleGreen ', N'#98FB98', NULL UNION ALL
SELECT 59, N'DarkOrchid ', N'#9932CC', NULL UNION ALL
SELECT 60, N'YellowGreen ', N'#9ACD32', NULL UNION ALL
SELECT 61, N'Sienna ', N'#A0522D', NULL UNION ALL
SELECT 62, N'Brown ', N'#A52A2A', NULL UNION ALL
SELECT 63, N'DarkGray ', N'#A9A9A9', NULL UNION ALL
SELECT 64, N'LightBlue ', N'#ADD8E6', NULL UNION ALL
SELECT 65, N'GreenYellow ', N'#ADFF2F', NULL UNION ALL
SELECT 66, N'PaleTurquoise ', N'#AFEEEE', NULL UNION ALL
SELECT 67, N'LightSteelBlue ', N'#B0C4DE', NULL UNION ALL
SELECT 68, N'PowderBlue ', N'#B0E0E6', NULL UNION ALL
SELECT 69, N'FireBrick ', N'#B22222', NULL UNION ALL
SELECT 70, N'DarkGoldenRod ', N'#B8860B', NULL UNION ALL
SELECT 71, N'MediumOrchid ', N'#BA55D3', NULL UNION ALL
SELECT 72, N'RosyBrown ', N'#BC8F8F', NULL UNION ALL
SELECT 73, N'DarkKhaki ', N'#BDB76B', NULL UNION ALL
SELECT 74, N'Silver ', N'#C0C0C0', NULL UNION ALL
SELECT 75, N'MediumVioletRed ', N'#C71585', NULL UNION ALL
SELECT 76, N'IndianRed  ', N'#CD5C5C', NULL UNION ALL
SELECT 77, N'Peru ', N'#CD853F', NULL UNION ALL
SELECT 78, N'Chocolate ', N'#D2691E', NULL UNION ALL
SELECT 79, N'Tan ', N'#D2B48C', NULL UNION ALL
SELECT 80, N'LightGrey ', N'#D3D3D3', NULL UNION ALL
SELECT 81, N'PaleVioletRed ', N'#D87093', NULL UNION ALL
SELECT 82, N'Thistle ', N'#D8BFD8', NULL UNION ALL
SELECT 83, N'Orchid ', N'#DA70D6', NULL UNION ALL
SELECT 84, N'GoldenRod ', N'#DAA520', NULL UNION ALL
SELECT 85, N'Crimson ', N'#DC143C', NULL UNION ALL
SELECT 86, N'Gainsboro ', N'#DCDCDC', NULL UNION ALL
SELECT 87, N'Plum ', N'#DDA0DD', NULL UNION ALL
SELECT 88, N'BurlyWood ', N'#DEB887', NULL UNION ALL
SELECT 89, N'LightCyan ', N'#E0FFFF', NULL UNION ALL
SELECT 90, N'Lavender ', N'#E6E6FA', NULL UNION ALL
SELECT 91, N'DarkSalmon ', N'#E9967A', NULL UNION ALL
SELECT 92, N'Violet ', N'#EE82EE', NULL UNION ALL
SELECT 93, N'PaleGoldenRod ', N'#EEE8AA', NULL UNION ALL
SELECT 94, N'LightCoral ', N'#F08080', NULL UNION ALL
SELECT 95, N'Khaki ', N'#F0E68C', NULL UNION ALL
SELECT 96, N'AliceBlue ', N'#F0F8FF', NULL UNION ALL
SELECT 97, N'HoneyDew ', N'#F0FFF0', NULL UNION ALL
SELECT 98, N'Azure ', N'#F0FFFF', NULL UNION ALL
SELECT 99, N'SandyBrown ', N'#F4A460', NULL UNION ALL
SELECT 100, N'Wheat ', N'#F5DEB3', NULL
COMMIT;
RAISERROR (N'[dbo].[Color]: Insert Batch: 2.....Done!', 10, 1) WITH NOWAIT;
GO
 
BEGIN TRANSACTION;
INSERT INTO [dbo].[Color]([ColorId], [ColorName], [ColorHex], [ColorDescription])
SELECT 101, N'Beige ', N'#F5F5DC', NULL UNION ALL
SELECT 102, N'WhiteSmoke ', N'#F5F5F5', NULL UNION ALL
SELECT 103, N'MintCream ', N'#F5FFFA', NULL UNION ALL
SELECT 104, N'GhostWhite ', N'#F8F8FF', NULL UNION ALL
SELECT 105, N'Salmon ', N'#FA8072', NULL UNION ALL
SELECT 106, N'AntiqueWhite ', N'#FAEBD7', NULL UNION ALL
SELECT 107, N'Linen ', N'#FAF0E6', NULL UNION ALL
SELECT 108, N'LightGoldenRodYellow ', N'#FAFAD2', NULL UNION ALL
SELECT 109, N'OldLace ', N'#FDF5E6', NULL UNION ALL
SELECT 110, N'Red ', N'#FF0000', NULL UNION ALL
SELECT 111, N'Fuchsia ', N'#FF00FF', NULL UNION ALL
SELECT 112, N'Magenta ', N'#FF00FF', NULL UNION ALL
SELECT 113, N'DeepPink ', N'#FF1493', NULL UNION ALL
SELECT 114, N'OrangeRed ', N'#FF4500', NULL UNION ALL
SELECT 115, N'Tomato ', N'#FF6347', NULL UNION ALL
SELECT 116, N'HotPink ', N'#FF69B4', NULL UNION ALL
SELECT 117, N'Coral ', N'#FF7F50', NULL UNION ALL
SELECT 118, N'Darkorange ', N'#FF8C00', NULL UNION ALL
SELECT 119, N'LightSalmon ', N'#FFA07A', NULL UNION ALL
SELECT 120, N'Orange ', N'#FFA500', NULL UNION ALL
SELECT 121, N'LightPink ', N'#FFB6C1', NULL UNION ALL
SELECT 122, N'Pink ', N'#FFC0CB', NULL UNION ALL
SELECT 123, N'Gold ', N'#FFD700', NULL UNION ALL
SELECT 124, N'PeachPuff ', N'#FFDAB9', NULL UNION ALL
SELECT 125, N'NavajoWhite ', N'#FFDEAD', NULL UNION ALL
SELECT 126, N'Moccasin ', N'#FFE4B5', NULL UNION ALL
SELECT 127, N'Bisque ', N'#FFE4C4', NULL UNION ALL
SELECT 128, N'MistyRose ', N'#FFE4E1', NULL UNION ALL
SELECT 129, N'BlanchedAlmond ', N'#FFEBCD', NULL UNION ALL
SELECT 130, N'PapayaWhip ', N'#FFEFD5', NULL UNION ALL
SELECT 131, N'LavenderBlush ', N'#FFF0F5', NULL UNION ALL
SELECT 132, N'SeaShell ', N'#FFF5EE', NULL UNION ALL
SELECT 133, N'Cornsilk ', N'#FFF8DC', NULL UNION ALL
SELECT 134, N'LemonChiffon ', N'#FFFACD', NULL UNION ALL
SELECT 135, N'FloralWhite ', N'#FFFAF0', NULL UNION ALL
SELECT 136, N'Snow ', N'#FFFAFA', NULL UNION ALL
SELECT 137, N'Yellow ', N'#FFFF00', NULL UNION ALL
SELECT 138, N'LightYellow ', N'#FFFFE0', NULL UNION ALL
SELECT 139, N'Ivory ', N'#FFFFF0', NULL UNION ALL
SELECT 140, N'White ', N'#FFFFFF', NULL
COMMIT;
RAISERROR (N'[dbo].[Color]: Insert Batch: 3.....Done!', 10, 1) WITH NOWAIT;
GO
 
SET IDENTITY_INSERT [dbo].[Color] OFF;

Labels

perl (41) Cheat Sheet (25) how-to (24) windows (14) sql server 2008 (13) linux (12) oracle (12) sql (12) Unix (11) cmd windows batch (10) mssql (10) cmd (9) script (9) textpad (9) netezza (8) sql server 2005 (8) cygwin (7) meta data mssql (7) metadata (7) bash (6) code generation (6) Informatica (5) cheatsheet (5) energy (5) tsql (5) utilities (5) excel (4) future (4) generic (4) html (4) perl modules (4) programs (4) settings (4) sh (4) shortcuts (4) поуки (4) принципи (4) Focus Fusion (3) Solaris (3) cool programs (3) development (3) economy (3) example (3) freeware (3) fusion (3) git cheat sheet (3) logging (3) morphus (3) mssql 2005 (3) nuclear (3) nz (3) parse (3) python (3) sftp (3) sofware development (3) source (3) sqlplus (3) table (3) vim (3) .Net (2) C# (2) China (2) GUI (2) Google (2) GoogleCL (2) Solaris Unix (2) ascii (2) awk (2) batch (2) cas (2) chrome extensions (2) code2html (2) columns (2) configuration (2) conversion (2) duplicates (2) excel shortcuts (2) export (2) file (2) free programs (2) informatica sql repository (2) linux cheat sheet (2) mssql 2008 (2) mysql (2) next big future (2) nsis (2) nz netezza cheat sheet (2) nzsql (2) ora (2) prediction (2) publish (2) release management (2) report (2) security (2) single-click (2) sqlserver 2005 (2) sqlserver 2008 (2) src (2) ssh (2) template (2) tools (2) vba (2) video (2) xlt (2) xml (2) youtube videos (2) *nix (1) .vimrc (1) .virmrc vim settings configs (1) BSD license (1) Bulgaria (1) Dallas (1) Database role (1) Dense plasma focus (1) Deployment (1) ERP (1) ExcelToHtml (1) GD (1) GDP (1) HP-UX (1) Hosting (1) INC (1) IT general (1) ITIL management bullshit-management (1) IZarc (1) Java Web Start (1) JavaScript anchor html jquery (1) Khan Academy (1) LINUX UNIX BASH AND CYGWIN TIPS AND TRICKS (1) Linux Unix rpm cpio build install configure (1) Linux git source build .configure make (1) ListBox (1) MIT HYDROGEN VIRUS (1) OO (1) Obama (1) PowerShell (1) Run-time (1) SDL (1) SIWA (1) SOX (1) Scala (1) Services (1) Stacks (1) SubSonic (1) TED (1) abstractions (1) ansible hosts linux bash (1) ansible linux deployment how-to (1) ansible yum pip python (1) apache (1) apache 2.2 (1) application life cycle (1) architecture (1) archive (1) arguments (1) avatar (1) aws cheat sheet cli (1) aws cli (1) aws cli amazon cheat sheet (1) aws elb (1) backup (1) bash Linux open-ssh ssh ssh_server ssh_client public-private key authentication (1) bash perl search and replace (1) bash stub (1) bin (1) biofuels (1) biology (1) books (1) browser (1) bubblesort (1) bugs (1) build (1) byte (1) cas_sql_dev (1) chennai (1) chrome (1) class (1) claut (1) cmdow (1) code generation sqlserver (1) command (1) command line (1) conf (1) confluence (1) console (1) convert (1) cool programs windows free freeware (1) copy-paste (1) csv (1) ctags (1) current local time (1) cygwin X11 port-forwarding mintty xclock Linux Unix X (1) cygwin bash how-to tips_n_tricks (1) cygwin conf how-to (1) data (1) data types (1) db2 cheat sheet (1) db2 starter ibm bash Linux (1) debt (1) diagram (1) dictionaries (1) digital (1) disk (1) disk space (1) documentation (1) dos (1) dubai (1) e-cars (1) electric cars (1) electricity (1) emulate (1) errors (1) exponents (1) export workflow (1) extract (1) fast export (1) fexp (1) file extension (1) file permissions (1) findtag (1) firewall (1) for loop (1) freaky (1) functions (1) fusion research (1) german (1) git gitlab issues handling system (1) google cli (1) google code (1) google command line interface (1) gpg (1) ha (1) head (1) helsinki (1) history (1) hop or flop (1) host-independant (1) how-to Windows cmd time date datetime (1) ibm db2 cognos installation example db deployment provisioning (1) ideas (1) image (1) informatica oracle sql (1) informatica repo sql workflows sessions file source dir (1) informatica source files etl (1) install (1) isg-pub issue-tracker architecture (1) it management best practices (1) java (1) jump to (1) keyboard shortcuts (1) ksh (1) level (1) linkedin (1) linux bash ansible hosts (1) linux bash commands (1) linux bash how-to shell expansion (1) linux bash shell grep xargs (1) linux bash tips and t ricks (1) linux bash unix cygwin cheatsheet (1) linux bash user accounts password (1) linux bash xargs space (1) linux cheat-sheet (1) linux cheatsheet cheat-sheet revised how-to (1) linux how-to non-root vim (1) linux ssh hosts parallel subshell bash oneliner (1) london (1) make (1) me (1) metacolumn (1) metadata functions (1) metaphonre (1) method (1) model (1) movie (1) multithreaded (1) mysql cheat sheet (1) mysql how-to table datatypes (1) n900 (1) nano (1) neteza (1) netezza bash linux nps (1) netezza nps (1) netezza nps nzsql (1) netezza nz Linux bash (1) netezza nz bash linux (1) netezza nz nzsql sql (1) netezza nzsql database db sizes (1) non-password (1) nord pol (1) nps backup nzsql schema (1) number formatting (1) nz db size (1) nz table count rows (1) nzsql date timestamp compare bigint to_date to_char now (1) on-lier (1) one-liners (1) one-to-many (1) oneliners (1) open (1) open source (1) openrowset (1) openssl (1) oracle PL/SQL (1) oracle Perl perl (1) oracle installation usability (1) oracle number formatting format-model ora-sql oracle (1) oracle templates create table (1) oracle trigger generic autoincrement (1) oracle vbox virtual box cheat sheet (1) oracle virtual box cheat sheet (1) outlook (1) parser (1) password (1) paths (1) perl @INC compile-time run-time (1) perl disk usage administration Linux Unix (1) perl modules configuration management (1) permissions (1) php (1) picasa (1) platform (1) postgreSQL how-to (1) powerShell cmd cygwin mintty.exe terminal (1) ppm (1) predictions (1) prices (1) principles (1) productivity (1) project (1) prompt (1) proxy account (1) public private key (1) publishing (1) putty (1) qt (1) read file (1) registry (1) relationship (1) repository (1) rm (1) scp (1) scripts (1) scsi (1) search and replace (1) sed (1) sendEmail (1) sh stub (1) shortcuts Windows sql developer Oracle (1) sidebar (1) silicon (1) smtp (1) software procurement (1) sofware (1) sort (1) sql script (1) sql_dev (1) sqlcmd (1) sqlite (1) sqlite3 (1) sshd (1) sshd cygwin (1) stackoverflow (1) stored procedure (1) stub (1) stupidity (1) subroutines (1) svn (1) sysinternals (1) tail (1) tar (1) temp table (1) templates (1) teradata (1) terminal (1) test (1) testing (1) theory (1) thorium (1) time (1) tip (1) title (1) tmux .tmux.conf configuration (1) tmux efficiency bash (1) tool (1) ui code prototyping tips and tricks (1) umask Linux Unix bash file permissions chmod (1) url (1) urls (1) user (1) utility (1) utils (1) vb (1) vbox virtual box cheat sheet (1) vim perl regex bash search for string (1) vim recursively hacks (1) vim starter (1) vim-cheat-sheet vim cheat-sheet (1) vimeo (1) visual stuio (1) warsaw (1) wiki (1) wikipedia (1) window (1) windows 7 (1) windows 8 (1) windows programs (1) windows reinstall (1) windows utility batch perl space Windows::Clipboard (1) wisdoms (1) workflow (1) worth-reading (1) wrapper (1) xp_cmdshell (1) xslt (1) youtube (1)

Blog Archive

Translate with Google Translate

My Blog List

VideoBar

This content is not yet available over encrypted connections.