SQL Data Types

So now that I'm studying for my 70-431 exam fully, I am writing out the datatypes:

 

• Exact Numeric (Used for precision data)
• Approximate Numeric (Used rarely, and appears to me to be a hangover from C)
• DateTime
• Money
• Character
• Binary  (this includes the image type most likely usedin Sharepoint for storing documents)
• Specialized (identity for primary keys, GUIDs, are two examples here)

Constraints:

• Check Constraints (These are set on tables)
• Rules (These are being phased out if not already in 2008, do not use), can be used outside of a table
• Unique Constraints (Prevents duplicate values in columns)
• Default Constraints
• Primary Key
• Foreign Key (this constraint ensures the value exists in another table already)