|
|
Posted by --CELKO-- on 09/17/05 06:40
1) How many people do you know or have ever heard of that have a name
that need to have CHAR(50)? The USPS allows CHAR(35)
2) Why did you violate common sense and ISO-11179 Standards with the
"tbI-" prefix?
3) Why don't you have a key? Why did you prevent having a key with
NULL_able? Why are you smarter than Dr. Codd?
4) If you knew SQL would this look like this:
CREATE TABLE FirstNames
(first_name VARCHAR (35) NOT NULL
CHECK (first_name = RTRIM(LTRIM(first_name))),
alternate_first_name VARCHAR (35) NOT NULL
CHECK (alternate_first_name = RTRIM(LTRIM(alternate_first_name))),
PRIMARY KEY (first_name, alternate_first_name)
);
>> I need want to construct a query which returns all names for a standard name plus the standard name itself. <<
SELECT first_name, alternate_first_name
FROM FirstNames
WHERE first_name = @my_guy;
Navigation:
[Reply to this message]
|