User Defined Type UDT

In this article we look at how to create a User Defined CLR Data Type to be used within SQL Server along with an example.

In this tip we look at the steps do modify a user defined table type in SQL Server because a simple ALTER or DROP doesn't work.

When stored as strings,email addresses sort by the user portion of the address instead of by the domain or the top level domain (TLD). That works for some applications, but in other applications queries would be faster if emails are stored in order by do