|
Wednesday, 21 February 2007 |
|
Enforcing poop honorableness ensures the singularity of material in a database. For example, if a aspiration is entered with a Product_ID emphasis of 25 in a handout named Products, the database should not allow another product to have an ID with the same value. Furthermore, if there is a column named Product_Rating that is intended to have values ranging from 1 to 10, the database should not accept a value below 1 and above 10 for this column. This can be accomplished by using the methods supported by SQL Server to enforce the integrity of the data. SQL Server supports a number of methods that can be used to enforce data integrity. These methods include defining datatypes, NOT NULL definitions, DEFAULT definitions, IDENTITY properties, rules, constraints, triggers, and indexes. |
|
Read more...
|