SQL Database Concepts Question: Download Questions PDF
Do you know what is user defined datatypes and when you should go for them?
Answer:
User defined data types are based on system data types. They should be used when multiple tables need to store the same type of data in a column and you need to ensure that all these columns are exactly the same including length, and nullability.
Parameters for user defined datatype:
Name
System data type on which user defined data type is based upon.
Nullability
For example, a user-defined data type called post_code could be created based on char system data type.
Parameters for user defined datatype:
Name
System data type on which user defined data type is based upon.
Nullability
For example, a user-defined data type called post_code could be created based on char system data type.
Download Basic SQL Server Interview Questions And Answers
PDF
Previous Question | Next Question |
Tell me what is difference between View and Materialized view? | Explain what is CTE (Common Table Expression)? |