I want to build a database for our system using Sql Server 2008 R2. but i need to know what are the best data types for storing these info:-
Telephone number with extension, such as +44 12345 ext 123
Rich Text editor. we have a field named "Position Role" or "Main duties", which stores a full description of each employee's roles.
Can anyone adivce on this please? Thanks