1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what are user defined datatypes and when you should go for them? : Sql server database administration

Question Posted / jyoti gupta


what are user defined datatypes and when you should go for them? : Sql server database administratio..

Answer / 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

More SQL Server Interview Questions

Explain how many types of relationship?

1 Answers  

What is your recommendation for a query running very slow? : sql server database administration

1 Answers  

How to get the definition of a stored procedure back?

1 Answers  

What are some examples of schemas?

1 Answers  

Do you know query execution plan?

1 Answers  

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1 Answers  

What is the difference between set and select?

1 Answers  

Explain transaction server auto commit?

1 Answers  

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

1 Answers  

Define compound operators?

1 Answers  

What is the default server name for sql server?

1 Answers  

What method is used by the Command classes to execute SQL statements that return single values?

1 Answers   B-Ways TecnoSoft,

For more SQL Server Interview Questions Click Here
Categories