Introduce Domain functionality to UDDT

Hot Topic

how to convert Cube to Report?
Join tables Count problems
How do you backup a database using sql server 2005 express???
SSIS will not start after SQL Server 2005 SP1 upgrade
Error in the PROCEDURE....
From MySQL to MSSQL 2005
Currency Conversions
Solutions and Projects: What are they and how do they help the DBA
How to disable Export
OPENROWSET using Visual FoxPro Provider error 'Could not fetch a row'

SQL Server

Decoding Decimal Form of HRESULT from ErrorCode
report viewer control wont display report !
How to handle multiple column conversions
Fast loading relational data
T Cannot connect to MSSAS 2005 Standard on local machine
Reading more than 1 set of files using Foreach Loop Container
Attach database from network drive
Help: I can open my database in Management Studio, but can't connect it in Integration Services
Upgrade Advisor and retrieving info on a cluster
Ordering Parameters Query Results?

Introduce Domain functionality to UDDT

As so rightly stated in http://www.microsoft.com/technet/prodtechnol/sql/70/books/inside6.mspx

"Currently, UDDTs don't support the notion of subtyping or inheritance, nor do they allow a DEFAULT value or CHECK constraint to be declared as part of the UDDT itself. These powerful object-oriented concepts will likely make their way into future versions of SQL Server. These limitations not withstanding, UDDT functionality is a dynamic and often underused feature of SQL Server."

There's no point bothering with using a UDDT in T-SQL if you can't apply constraints to the UDDT!

1 vote for the introduction of the mentioned features into T-SQL

comments anyone


Answer this question

Introduce Domain functionality to UDDT

  • DaCracker_2005

    Hi Kevin your link references SQL 7.0, which is almost 10 years old :) Much of this can be accomplished in SQL 2005.

  • The Saint

    Hey, I don't blame you. They have some cool power, but a bit too much complexity for my taste. I do hope they give us easier to use domain support in the future, but not yet :)

  • heroesch

    I have been trying to avoid CLR UDTs for the simple tasks I'm doing. But you're right they are powerful. I'm simply struggling to let go of SQL domains for the sole purpose of not having to rewrite a few constraints.

  • Geert_

    Ah, my bad.

    Sorry I'm having a lot of trouble finding quality information on how to use a UDDT as a domain in T-SQL. I thought the above was why, instead it must have been my inability to search properly.

    I just found the concept applying a RULE to a UDDT which should help...

    Thanks Greg, at least now I know I should keep looking.

  • rothco

    T-SQL UDTs still lack this functionality, and rules are being depricated and won't be around very long.

    If you are willing to use the CLR, the sky is the limit, but it is not altogether easy or straightforward how to use them. Start with the 2005 books online, under UDTs [CLR integration].



  • Introduce Domain functionality to UDDT
Answer this question