what are user defined datatypes and when you should go for them? : Sql server database administration
- 1 Answers
- 1090 Views
- I also Faced
- E-Mail Answers
Answer Posted / Anupam Raj
"User-defined data types (UDTs) in SQL Server allow you to create custom data types that consist of a combination of built-in data types. UDTs can help improve data integrity, reduce redundancy, and simplify complex queries by allowing you to encapsulate related data into a single entity. UDTs are useful when you have specific requirements for the structure or validation of your data."n
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List the ways in which dynamic sql can be executed?
Explain system functions or built-in functions? What are different types of system functions?
What are the source of constraints?
How raid can influence database performance?
What are the kinds of subquery?
What is the primary use of the model database?
How do I find the sql server version?
How can I check that whether automatic statistic update is enabled or not?
What are the properties of the transaction?
Why use identity in sql server?
Can we do dml on views?
How to provide default values to function parameters?
Equi join and non equi join is possible with sql server?
Does view occupy space?
Why we use the openxml clause?
