InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Are User Defined Datatypes And When You Should Go For Them? |
|
Answer» USER defined datatypes let you extend the base SQL SERVER datatypes by providing a descriptive name, and format to the database. TAKE for example, in your database, there is a column called Flight_Num which appears in many TABLES. In all these tables it should be varchar(8). In this CASE you could create a user defined datatype called Flight_num_type of varchar(8) and use it across all your tables. User defined datatypes let you extend the base SQL Server datatypes by providing a descriptive name, and format to the database. Take for example, in your database, there is a column called Flight_Num which appears in many tables. In all these tables it should be varchar(8). In this case you could create a user defined datatype called Flight_num_type of varchar(8) and use it across all your tables. |
|