Question

请教一道SQL题目, 给出答案加100分, 谢谢大家

1. Design a SQL table that stored the customer master information. Write a simple SQL view, form and stored procedure to extract the customer information from database and display on the screen base on some searching criteria entered. Please state the input, process and output of the entire operation. The coding should include some basic validation rule on the searching criteria entered. (Logical thinking and programming skill test).

Searching Criteria : Customer Name, Identification Number or Birth Date.

Answer 1

设计一个存储客户信息的表，写一个能从表中根据条件查询客户信息并显示出来的简单的视图和存储过程，请陈诉整个操作的输入，程序流程以及输出情况。程序应该对查询条件有一些基本的有效性检查（逻辑想法和编程技巧测试）
查询标准：客户名，索引号或出生年月

select * from customer where CustomerName=trim(Customer Name)

....

Answer 2

我英语不好。你先找人翻译了。

Answer 3

本人英语也很垃圾,翻译先