IF OBJECT_ID('dbo.Row apperance', 'U') IS NOT NULL DROP TABLE [Row apperance] CREATE TABLE [Row apperance] ( [ID] INT Identity(1,1) PRIMARY KEY ,[Row_Activated] BIT ,[Row_Activation] NVARCHAR(50) --Activation ,[Row_AllowFixing] NVARCHAR(10) --DefaultableBoolean ,[Row_AlphaLevel] INT -- 0-255 ,[Row_BackColor] NVARCHAR(50) -- Color ,[Row_BackColor2] NVARCHAR(50) -- Color ,[Row_BackColorAlpha] NVARCHAR(50) -- Alpha ,[Row_BackColorDisabled] NVARCHAR(50) -- Color ,[Row_BackColorDisabled2] NVARCHAR(50) -- Color ,[Row_BackGradientAlignment] NVARCHAR(50) -- GradientAlignment ,[Row_BackGradientStyle] NVARCHAR(50) -- GradientStyle ,[Row_BorderAlpha] NVARCHAR(50) -- Alpha ,[Row_BorderColor] NVARCHAR(50) -- Color ,[Row_BorderColor2] NVARCHAR(50) -- Color ,[Row_BorderColor3DBase] NVARCHAR(50) -- Color ,[Row_CardCaption] NVARCHAR(100) --Text ,[Row_Description] NVARCHAR(100) --Text ,[Row_Expanded] BIT ,[Row_ExpansionIndicator] NVARCHAR(50) --ShowExpansionIndicator ,[Row_Fixed] BIT ,[Row_FixedHeight] INT --,[Row_FixedRows] BIT ,[Row_FontData_Bold] NVARCHAR(10) --DefaultableBoolean ,[Row_FontData_Italic] NVARCHAR(10) --DefaultableBoolean ,[Row_FontData_SizeInPoints] INT ,[Row_FontData_Strikeout] NVARCHAR(10) --DefaultableBoolean ,[Row_FontData_Underline] NVARCHAR(10) --DefaultableBoolean ,[Row_ForeColor] NVARCHAR(50) -- Color ,[Row_ForeColorDisabled] NVARCHAR(50) -- Color ,[Row_ForegroundAlpha] NVARCHAR(50) -- Alpha ,[Row_Height] INT ,[Row_Hidden] BIT ,[Row_RowSpacingAfter] INT ,[Row_RowSpacingBefore] INT ,[Row_Selected] BIT ,[Row_TextHAlign] NVARCHAR(50) -- HAlign ,[Row_TextTrimming] NVARCHAR(50) -- TextTrimming ,[Row_TextVAlign] NVARCHAR(50) -- VAlign ,[Row_ThemedElementAlpha] NVARCHAR(50) -- Alpha ,[Row_ToolTipText] NVARCHAR(100) --Text ) IF OBJECT_ID('dbo.Appearances', 'U') IS NOT NULL DROP TABLE [Appearances] CREATE TABLE [Appearances] ([ID] INT Identity(1,1) PRIMARY KEY ,[Appearance ID] NVARCHAR(50) ,[Value] NVARCHAR(50)) --TRUNCATE TABLE [Appearances] INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Activation', NULL) INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Activation', 'ActiveOnly') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Activation', 'AllowEdit') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Activation', 'Disabled') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Activation', 'NoEdit') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Alpha', NULL) INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Alpha', 'Default') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Alpha', 'Opaque') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Alpha', 'Transparent') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Alpha', 'UseAlphaLevel') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', NULL) INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '0') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '1') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '2') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '3') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '4') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '5') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '6') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '7') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '8') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '9') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '10') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '11') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '12') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '13') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '14') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '15') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '16') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '17') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '18') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '19') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '20') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '21') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '22') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '23') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '24') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '25') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '26') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '27') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '28') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '29') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '30') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '31') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '32') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '33') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '34') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '35') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '36') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '37') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '38') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '39') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '40') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '41') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '42') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '43') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '44') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '45') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '46') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '47') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '48') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '49') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '50') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '51') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '52') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '53') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '54') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '55') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '56') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '57') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '58') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '59') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '60') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '61') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '62') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '63') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '64') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '65') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '66') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '67') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '68') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '69') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '70') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '71') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '72') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '73') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '74') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '75') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '76') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '77') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '78') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '79') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '80') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '81') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '82') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '83') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '84') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '85') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '86') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '87') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '88') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '89') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '90') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '91') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '92') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '93') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '94') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '95') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '96') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '97') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '98') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '99') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '100') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '101') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '102') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '103') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '104') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '105') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '106') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '107') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '108') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '109') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '110') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '111') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '112') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '113') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '114') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '115') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '116') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '117') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '118') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '119') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '120') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '121') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '122') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '123') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '124') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '125') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '126') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '127') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '128') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '129') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '130') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '131') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '132') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '133') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '134') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '135') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '136') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '137') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '138') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '139') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '140') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '141') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '142') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '143') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '144') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '145') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '146') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '147') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '148') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '149') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '150') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '151') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '152') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '153') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '154') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '155') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '156') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '157') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '158') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '159') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '160') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '161') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '162') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '163') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '164') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '165') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '166') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '167') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '168') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '169') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '170') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '171') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '172') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '173') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '174') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '175') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '176') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '177') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '178') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '179') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '180') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '181') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '182') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '183') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '184') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '185') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '186') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '187') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '188') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '189') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '190') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '191') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '192') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '193') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '194') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '195') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '196') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '197') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '198') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '199') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '200') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '201') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '202') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '203') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '204') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '205') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '206') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '207') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '208') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '209') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '210') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '211') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '212') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '213') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '214') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '215') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '216') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '217') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '218') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '219') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '220') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '221') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '222') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '223') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '224') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '225') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '226') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '227') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '228') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '229') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '230') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '231') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '232') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '233') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '234') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '235') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '236') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '237') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '238') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '239') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '240') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '241') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '242') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '243') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '244') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '245') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '246') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '247') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '248') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '249') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '250') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '251') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '252') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '253') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '254') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('AlphaLevel', '255') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Boolean', NULL) INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Boolean', '0') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Boolean', '1') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', NULL) INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'AliceBlue') -- Gets a system-defined color that has an ARGB value of #FFF0F8FF. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'AntiqueWhite') -- Gets a system-defined color that has an ARGB value of #FFFAEBD7. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Aqua') -- Gets a system-defined color that has an ARGB value of #FF00FFFF. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Aquamarine') -- Gets a system-defined color that has an ARGB value of #FF7FFFD4. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Azure') -- Gets a system-defined color that has an ARGB value of #FFF0FFFF. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Beige') -- Gets a system-defined color that has an ARGB value of #FFF5F5DC. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Bisque') -- Gets a system-defined color that has an ARGB value of #FFFFE4C4. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Black') -- Gets a system-defined color that has an ARGB value of #FF000000. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'BlanchedAlmond') -- Gets a system-defined color that has an ARGB value of #FFFFEBCD. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Blue') -- Gets a system-defined color that has an ARGB value of #FF0000FF. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'BlueViolet') -- Gets a system-defined color that has an ARGB value of #FF8A2BE2. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Brown') -- Gets a system-defined color that has an ARGB value of #FFA52A2A. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'BurlyWood') -- Gets a system-defined color that has an ARGB value of #FFDEB887. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'CadetBlue') -- Gets a system-defined color that has an ARGB value of #FF5F9EA0. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Chartreuse') -- Gets a system-defined color that has an ARGB value of #FF7FFF00. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Chocolate') -- Gets a system-defined color that has an ARGB value of #FFD2691E. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Coral') -- Gets a system-defined color that has an ARGB value of #FFFF7F50. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'CornflowerBlue') -- Gets a system-defined color that has an ARGB value of #FF6495ED. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Cornsilk') -- Gets a system-defined color that has an ARGB value of #FFFFF8DC. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Crimson') -- Gets a system-defined color that has an ARGB value of #FFDC143C. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Cyan') -- Gets a system-defined color that has an ARGB value of #FF00FFFF. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkBlue') -- Gets a system-defined color that has an ARGB value of #FF00008B. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkCyan') -- Gets a system-defined color that has an ARGB value of #FF008B8B. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkGoldenrod') -- Gets a system-defined color that has an ARGB value of #FFB8860B. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkGray') -- Gets a system-defined color that has an ARGB value of #FFA9A9A9. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkGreen') -- Gets a system-defined color that has an ARGB value of #FF006400. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkKhaki') -- Gets a system-defined color that has an ARGB value of #FFBDB76B. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkMagenta') -- Gets a system-defined color that has an ARGB value of #FF8B008B. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkOliveGreen') -- Gets a system-defined color that has an ARGB value of #FF556B2F. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkOrange') -- Gets a system-defined color that has an ARGB value of #FFFF8C00. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkOrchid') -- Gets a system-defined color that has an ARGB value of #FF9932CC. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkRed') -- Gets a system-defined color that has an ARGB value of #FF8B0000. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkSalmon') -- Gets a system-defined color that has an ARGB value of #FFE9967A. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkSeaGreen') -- Gets a system-defined color that has an ARGB value of #FF8FBC8F. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkSlateBlue') -- Gets a system-defined color that has an ARGB value of #FF483D8B. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkSlateGray') -- Gets a system-defined color that has an ARGB value of #FF2F4F4F. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkTurquoise') -- Gets a system-defined color that has an ARGB value of #FF00CED1. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DarkViolet') -- Gets a system-defined color that has an ARGB value of #FF9400D3. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DeepPink') -- Gets a system-defined color that has an ARGB value of #FFFF1493. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DeepSkyBlue') -- Gets a system-defined color that has an ARGB value of #FF00BFFF. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DimGray') -- Gets a system-defined color that has an ARGB value of #FF696969. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'DodgerBlue') -- Gets a system-defined color that has an ARGB value of #FF1E90FF. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Firebrick') -- Gets a system-defined color that has an ARGB value of #FFB22222. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'FloralWhite') -- Gets a system-defined color that has an ARGB value of #FFFFFAF0. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'ForestGreen') -- Gets a system-defined color that has an ARGB value of #FF228B22. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Fuchsia') -- Gets a system-defined color that has an ARGB value of #FFFF00FF. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Gainsboro') -- Gets a system-defined color that has an ARGB value of #FFDCDCDC. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'GhostWhite') -- Gets a system-defined color that has an ARGB value of #FFF8F8FF. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Gold') -- Gets a system-defined color that has an ARGB value of #FFFFD700. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Goldenrod') -- Gets a system-defined color that has an ARGB value of #FFDAA520. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Gray') -- Gets a system-defined color that has an ARGB value of #FF808080. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Green') -- Gets a system-defined color that has an ARGB value of #FF008000. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'GreenYellow') -- Gets a system-defined color that has an ARGB value of #FFADFF2F. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Honeydew') -- Gets a system-defined color that has an ARGB value of #FFF0FFF0. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'HotPink') -- Gets a system-defined color that has an ARGB value of #FFFF69B4. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'IndianRed') -- Gets a system-defined color that has an ARGB value of #FFCD5C5C. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Indigo') -- Gets a system-defined color that has an ARGB value of #FF4B0082. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Ivory') -- Gets a system-defined color that has an ARGB value of #FFFFFFF0. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Khaki') -- Gets a system-defined color that has an ARGB value of #FFF0E68C. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Lavender') -- Gets a system-defined color that has an ARGB value of #FFE6E6FA. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LavenderBlush') -- Gets a system-defined color that has an ARGB value of #FFFFF0F5. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LawnGreen') -- Gets a system-defined color that has an ARGB value of #FF7CFC00. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LemonChiffon') -- Gets a system-defined color that has an ARGB value of #FFFFFACD. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LightBlue') -- Gets a system-defined color that has an ARGB value of #FFADD8E6. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LightCoral') -- Gets a system-defined color that has an ARGB value of #FFF08080. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LightCyan') -- Gets a system-defined color that has an ARGB value of #FFE0FFFF. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LightGoldenrodYellow') -- Gets a system-defined color that has an ARGB value of #FFFAFAD2. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LightGray') -- Gets a system-defined color that has an ARGB value of #FFD3D3D3. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LightGreen') -- Gets a system-defined color that has an ARGB value of #FF90EE90. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LightPink') -- Gets a system-defined color that has an ARGB value of #FFFFB6C1. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LightSalmon') -- Gets a system-defined color that has an ARGB value of #FFFFA07A. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LightSeaGreen') -- Gets a system-defined color that has an ARGB value of #FF20B2AA. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LightSkyBlue') -- Gets a system-defined color that has an ARGB value of #FF87CEFA. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LightSlateGray') -- Gets a system-defined color that has an ARGB value of #FF778899. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LightSteelBlue') -- Gets a system-defined color that has an ARGB value of #FFB0C4DE. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LightYellow') -- Gets a system-defined color that has an ARGB value of #FFFFFFE0. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Lime') -- Gets a system-defined color that has an ARGB value of #FF00FF00. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'LimeGreen') -- Gets a system-defined color that has an ARGB value of #FF32CD32. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Linen') -- Gets a system-defined color that has an ARGB value of #FFFAF0E6. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Magenta') -- Gets a system-defined color that has an ARGB value of #FFFF00FF. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Maroon') -- Gets a system-defined color that has an ARGB value of #FF800000. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'MediumAquamarine') -- Gets a system-defined color that has an ARGB value of #FF66CDAA. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'MediumBlue') -- Gets a system-defined color that has an ARGB value of #FF0000CD. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'MediumOrchid') -- Gets a system-defined color that has an ARGB value of #FFBA55D3. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'MediumPurple') -- Gets a system-defined color that has an ARGB value of #FF9370DB. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'MediumSeaGreen') -- Gets a system-defined color that has an ARGB value of #FF3CB371. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'MediumSlateBlue') -- Gets a system-defined color that has an ARGB value of #FF7B68EE. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'MediumSpringGreen') -- Gets a system-defined color that has an ARGB value of #FF00FA9A. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'MediumTurquoise') -- Gets a system-defined color that has an ARGB value of #FF48D1CC. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'MediumVioletRed') -- Gets a system-defined color that has an ARGB value of #FFC71585. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'MidnightBlue') -- Gets a system-defined color that has an ARGB value of #FF191970. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'MintCream') -- Gets a system-defined color that has an ARGB value of #FFF5FFFA. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'MistyRose') -- Gets a system-defined color that has an ARGB value of #FFFFE4E1. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Moccasin') -- Gets a system-defined color that has an ARGB value of #FFFFE4B5. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'NavajoWhite') -- Gets a system-defined color that has an ARGB value of #FFFFDEAD. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Navy') -- Gets a system-defined color that has an ARGB value of #FF000080. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'OldLace') -- Gets a system-defined color that has an ARGB value of #FFFDF5E6. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Olive') -- Gets a system-defined color that has an ARGB value of #FF808000. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'OliveDrab') -- Gets a system-defined color that has an ARGB value of #FF6B8E23. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Orange') -- Gets a system-defined color that has an ARGB value of #FFFFA500. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'OrangeRed') -- Gets a system-defined color that has an ARGB value of #FFFF4500. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Orchid') -- Gets a system-defined color that has an ARGB value of #FFDA70D6. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'PaleGoldenrod') -- Gets a system-defined color that has an ARGB value of #FFEEE8AA. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'PaleGreen') -- Gets a system-defined color that has an ARGB value of #FF98FB98. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'PaleTurquoise') -- Gets a system-defined color that has an ARGB value of #FFAFEEEE. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'PaleVioletRed') -- Gets a system-defined color that has an ARGB value of #FFDB7093. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'PapayaWhip') -- Gets a system-defined color that has an ARGB value of #FFFFEFD5. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'PeachPuff') -- Gets a system-defined color that has an ARGB value of #FFFFDAB9. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Peru') -- Gets a system-defined color that has an ARGB value of #FFCD853F. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Pink') -- Gets a system-defined color that has an ARGB value of #FFFFC0CB. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Plum') -- Gets a system-defined color that has an ARGB value of #FFDDA0DD. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'PowderBlue') -- Gets a system-defined color that has an ARGB value of #FFB0E0E6. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Purple') -- Gets a system-defined color that has an ARGB value of #FF800080. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Red') -- Gets a system-defined color that has an ARGB value of #FFFF0000. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'RosyBrown') -- Gets a system-defined color that has an ARGB value of #FFBC8F8F. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'RoyalBlue') -- Gets a system-defined color that has an ARGB value of #FF4169E1. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'SaddleBrown') -- Gets a system-defined color that has an ARGB value of #FF8B4513. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Salmon') -- Gets a system-defined color that has an ARGB value of #FFFA8072. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'SandyBrown') -- Gets a system-defined color that has an ARGB value of #FFF4A460. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'SeaGreen') -- Gets a system-defined color that has an ARGB value of #FF2E8B57. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'SeaShell') -- Gets a system-defined color that has an ARGB value of #FFFFF5EE. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Sienna') -- Gets a system-defined color that has an ARGB value of #FFA0522D. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Silver') -- Gets a system-defined color that has an ARGB value of #FFC0C0C0. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'SkyBlue') -- Gets a system-defined color that has an ARGB value of #FF87CEEB. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'SlateBlue') -- Gets a system-defined color that has an ARGB value of #FF6A5ACD. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'SlateGray') -- Gets a system-defined color that has an ARGB value of #FF708090. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Snow') -- Gets a system-defined color that has an ARGB value of #FFFFFAFA. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'SpringGreen') -- Gets a system-defined color that has an ARGB value of #FF00FF7F. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'SteelBlue') -- Gets a system-defined color that has an ARGB value of #FF4682B4. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Tan') -- Gets a system-defined color that has an ARGB value of #FFD2B48C. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Teal') -- Gets a system-defined color that has an ARGB value of #FF008080. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Thistle') -- Gets a system-defined color that has an ARGB value of #FFD8BFD8. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Tomato') -- Gets a system-defined color that has an ARGB value of #FFFF6347. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Turquoise') -- Gets a system-defined color that has an ARGB value of #FF40E0D0. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Violet') -- Gets a system-defined color that has an ARGB value of #FFEE82EE. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Wheat') -- Gets a system-defined color that has an ARGB value of #FFF5DEB3. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'White') -- Gets a system-defined color that has an ARGB value of #FFFFFFFF. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'WhiteSmoke') -- Gets a system-defined color that has an ARGB value of #FFF5F5F5. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'Yellow') -- Gets a system-defined color that has an ARGB value of #FFFFFF00. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('Color', 'YellowGreen') -- Gets a system-defined color that has an ARGB value of #FF9ACD32. INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('DefaultableBoolean', NULL) INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('DefaultableBoolean', 'Default') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('DefaultableBoolean', 'False') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('DefaultableBoolean', 'True') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientAlignment', NULL) INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientAlignment', 'Client') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientAlignment', 'Container') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientAlignment', 'Default') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientAlignment', 'Element') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientAlignment', 'Form') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', NULL) INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'BackwardDiagonal') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'Circular') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'Default') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'Elliptical') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'ForwardDiagonal') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassBottom20') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassBottom20Bright') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassBottom37') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassBottom37Bright') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassBottom50') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassBottom50Bright') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassLeft20') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassLeft20Bright') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassLeft37') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassLeft37Bright') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassLeft50') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassLeft50Bright') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassRight20') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassRight20Bright') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassRight37') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassRight37Bright') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassRight50') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassRight50Bright') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassTop20') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassTop20Bright') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassTop37') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassTop37Bright') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassTop50') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'GlassTop50Bright') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'Horizontal') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'HorizontalBump') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'HorizontalWithGlassBottom50') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'HorizontalWithGlassTop50') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'None') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'Rectangular') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'Vertical') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'VerticalBump') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'VerticalWithGlassLeft50') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('GradientStyle', 'VerticalWithGlassRight50') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('HAlign', NULL) INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('HAlign', 'Center') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('HAlign', 'Default') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('HAlign', 'Left') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('HAlign', 'Right') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('ShowExpansionIndicator', NULL) INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('ShowExpansionIndicator', 'Always') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('ShowExpansionIndicator', 'CheckOnDisplay') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('ShowExpansionIndicator', 'CheckOnExpand') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('ShowExpansionIndicator', 'Default') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('ShowExpansionIndicator', 'Never') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('TextTrimming', NULL) INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('TextTrimming', 'Character') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('TextTrimming', 'CharacterWithLineLimit') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('TextTrimming', 'Default') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('TextTrimming', 'EllipsisCharacter') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('TextTrimming', 'EllipsisCharacterWithLineLimit') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('TextTrimming', 'EllipsisPath') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('TextTrimming', 'EllipsisPathWithLineLimit') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('TextTrimming', 'EllipsisWord') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('TextTrimming', 'EllipsisWordWithLineLimit') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('TextTrimming', 'None') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('TextTrimming', 'NoneWithLineLimit') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('TextTrimming', 'Word') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('TextTrimming', 'WordWithLineLimit') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('VAlign', NULL) INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('VAlign', 'Bottom') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('VAlign', 'Default') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('VAlign', 'Middle') INSERT INTO [Appearances] ([Appearance ID], [Value]) VALUES ('VAlign', 'Top') GO DECLARE @_Rows INT SET @_Rows = 1000 WHILE @_Rows > 0 BEGIN SET @_Rows = @_Rows - 1 INSERT INTO [Row apperance] ([Row_Activated] ,[Row_Activation] ,[Row_AllowFixing] ,[Row_AlphaLevel] ,[Row_BackColor] ,[Row_BackColor2] ,[Row_BackColorAlpha] ,[Row_BackColorDisabled] ,[Row_BackColorDisabled2] ,[Row_BackGradientAlignment] ,[Row_BackGradientStyle] ,[Row_BorderAlpha] ,[Row_BorderColor] ,[Row_BorderColor2] ,[Row_BorderColor3DBase] ,[Row_CardCaption] ,[Row_Description] ,[Row_Expanded] ,[Row_ExpansionIndicator] ,[Row_Fixed] ,[Row_FixedHeight] -- ,[Row_FixedRows] ,[Row_FontData_Bold] ,[Row_FontData_Italic] ,[Row_FontData_SizeInPoints] ,[Row_FontData_Strikeout] ,[Row_FontData_Underline] ,[Row_ForeColor] ,[Row_ForeColorDisabled] ,[Row_ForegroundAlpha] ,[Row_Height] ,[Row_Hidden] ,[Row_RowSpacingAfter] ,[Row_RowSpacingBefore] ,[Row_Selected] ,[Row_TextHAlign] ,[Row_TextTrimming] ,[Row_TextVAlign] ,[Row_ThemedElementAlpha] ,[Row_ToolTipText]) SELECT (SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Boolean' ORDER BY NEWID()) AS [Row_Activated] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Activation' ORDER BY NEWID()) AS [Row_Activation] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'DefaultableBoolean' ORDER BY NEWID()) AS [Row_AllowFixing] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'AlphaLevel' ORDER BY NEWID()) AS [Row_AlphaLevel] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Color' ORDER BY NEWID()) AS [Row_BackColor] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Color' ORDER BY NEWID()) AS [Row_BackColor2] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Alpha' ORDER BY NEWID()) AS [Row_BackColorAlpha] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Color' ORDER BY NEWID()) AS [Row_BackColorDisabled] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Color' ORDER BY NEWID()) AS [Row_BackColorDisabled2] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'GradientAlignment' ORDER BY NEWID()) AS [Row_BackGradientAlignment] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'GradientStyle' ORDER BY NEWID()) AS [Row_BackGradientStyle] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Alpha' ORDER BY NEWID()) AS [Row_BorderAlpha] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Color' ORDER BY NEWID()) AS [Row_BorderColor] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Color' ORDER BY NEWID()) AS [Row_BorderColor2] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Color' ORDER BY NEWID()) AS [Row_BorderColor3DBase] ,(SELECT 'CardCaption text' AS [Value]) AS [Row_CardCaption] ,(SELECT 'Description text' AS [Value]) AS [Row_Description] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Boolean' ORDER BY NEWID()) AS [Row_Expanded] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'ShowExpansionIndicator' ORDER BY NEWID()) AS [Row_ExpansionIndicator] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Boolean' ORDER BY NEWID()) AS [Row_Fixed] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'AlphaLevel' AND CONVERT(INT, ISNULL([Value], 0)) < 30 ORDER BY NEWID()) AS [Row_FixedHeight] --,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Boolean' ORDER BY NEWID()) AS [Row_FixedRows] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'DefaultableBoolean' ORDER BY NEWID()) AS [Row_FontData_Bold] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'DefaultableBoolean' ORDER BY NEWID()) AS [Row_FontData_Italic] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'AlphaLevel' AND CONVERT(INT, ISNULL([Value], 0)) < 30 ORDER BY NEWID()) AS [Row_FontData_SizeInPoints] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'DefaultableBoolean' ORDER BY NEWID()) AS [Row_FontData_Strikeout] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'DefaultableBoolean' ORDER BY NEWID()) AS [Row_FontData_Underline] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Color' ORDER BY NEWID()) AS [Row_ForeColor] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Color' ORDER BY NEWID()) AS [Row_ForeColorDisabled] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Alpha' ORDER BY NEWID()) AS [Row_ForegroundAlpha] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'AlphaLevel' AND CONVERT(INT, ISNULL([Value], 0)) < 30 ORDER BY NEWID()) AS [Row_Height] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Boolean' ORDER BY NEWID()) AS [Row_Hidden] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'AlphaLevel' AND CONVERT(INT, ISNULL([Value], 0)) < 30 ORDER BY NEWID()) AS [Row_RowSpacingAfter] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'AlphaLevel' AND CONVERT(INT, ISNULL([Value], 0)) < 30 ORDER BY NEWID()) AS [Row_RowSpacingBefore] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Boolean' ORDER BY NEWID()) AS [Row_Selected] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'HAlign' ORDER BY NEWID()) AS [Row_TextHAlign] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'TextTrimming' ORDER BY NEWID()) AS [Row_TextTrimming] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'VAlign' ORDER BY NEWID()) AS [Row_TextVAlign] ,(SELECT TOP 1 [Value] FROM [Appearances] WHERE [Appearance ID] = 'Alpha' ORDER BY NEWID()) AS [Row_ThemedElementAlpha] ,(SELECT 'ToolTipText text' AS [Value]) AS [Row_ToolTipText] END