|
Home > Archive > SQL server exams > August 2001 > A question for 029
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
A question for 029
|
|
|
| Q: You would like to create a view of table for users to input data. The view must restrict the maximum entry to 100,000. How can this be done without the use of a database trigger?
A: Create and bind a rule.
slam: my initial answer is 'using the check contraint'. Can anyone tell me why is uses a rule (instead of a check contraint) here, or there's something wrong with the given answer? Thanks!!
 | |
| naeem 2001-08-26, 10:12 pm |
| the correct answer is only check constraint as the rule is normally used for one item to be selected among the list of the items |
|
|
|
|