Do you know what is user defined datatypes and when you should go for them?



Do you know what is user defined datatypes and when you should go for them?..

Answer / Sanjay Kumar Joshi

User-defined data types (UDTs) are custom data types that you can create in SQL Server to improve the organization, maintenance, and security of your data. UDTs allow you to group related columns together and enforce consistency across the database. You should consider using UDTs when you have complex data structures or need to ensure that the data conforms to specific business rules.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is user defined stored procedures?

1 Answers  


What does it mean to normalize data?

1 Answers  


You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

1 Answers  


How to trouble shoot if unable to connect SQL Server

1 Answers  


Tell me extended events in sql server 2008?

1 Answers  


What is a stored procedure?

3 Answers  


How can i Relate Tables in SSIS

1 Answers   HCL,


What is use of except clause?

1 Answers  


Explain active/passive and active/active cluster configurations?

1 Answers  


Explain different isolation levels?

4 Answers  


What is sql server english query?

1 Answers  


What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,


Categories