devxlogo

April 21, 1997

Updating Many Columns

Question: I’m looking for a syntax that can be used to update several columns in an SQLtable. Although I’ve found a number of topics related to ‘update’, they allseem to

What is normalization?

Question: Will you please help me in locating a definition of the term “normalizeddatabase”? Answer: Normalization of relational databases is the process of ensuring that thedatabase does not contain redundant

Length of Table and Column Descriptors

Question: What is the length of a table name or a column name?I know that for some engines it is 18 characters.Is this a SQL limitation or engine limitation ?

WHERE (multiple values)

Question: I have a form in which the user can select multiple values of “Manufacturer” from a drop-down list. The query should then select from the database all records in