Export (0) Print
Expand All

English Data Values Dialog Box

SQL Server 2000

Use this dialog box to specify English data values.

When the adjectives or subset words used to describe a relationship are defined in an entity, you can specify that they be found either in a database field or in a specified set of word-value pairs. For example, a lookup table can contain gender codes and the values they represent, M for Male and F for Female.

Options

Read English from table

Indicate that the adjective or subset entity contains codes and adjectives or subset words that must be looked up in a lookup table.

Table

Select a table that contains the fields in which adjective or subset words are stored. An example is the Gender Codes table.

Available only if you select Read English from table.

Word field

Select the field that contains the descriptive words in the adjective or subset phrasing.

Available only if you select Read English from table.

Value field

Select the field that contains the codes in the adjective or subset phrasing.

Available only if you select Read English from table.

Specify values

Specify a lookup table, which contains the values that serve as the adjectives or subset words in the relationship (for example, M, Male and F, Female).Word and Value

Enter the word and its associated values. Although you can enter only one entry per line, you can have multiple words or multiple values. For example, Male could be entered as the word, as the value, M, and as the value, Y. Female could be entered as the word, as the value F, and as the value, X. Unknown could be entered as U.

Available only if you select Specify values.

Show:
© 2014 Microsoft