• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

user defined elements in Sql Server - relative purpose and benefits.

user defined column data types has existed for a while in SQL Server.

Now recently they have introduced user defined table type.

Are the benefits the same between the above two? Are they are similar in benefits?

the primary benefit i realize for user-defined data types is that they add the ability to describe data data elements. Both first name and city can be varchar(25), but if I have one user type definited for first name and one for city, it describes itself more clearly and less error.. is this the same kind of benefit to expect from user defined table types?

why did MS wait or delay in introducing user defined table types, compared to user defined data types?
1 Solution
The most important benefit of user defined table type is that allows to pass a table as parameter to a stored procedure, which was not possible before 2008. In order to do that the table has to be a table variable  of user defined type not just regular table variable.

Here is an article about it:

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now