开发者

Domains in SQL Server?

I've just been reading 'Give us Real Domains!' on SQL Server MVP Erland Sommarskog's SQL Server Wishlist.

I was thinking of trying out CREATE TYPE with bound rules but was alarmed to learn that 开发者_开发知识库this is a deprecated feature.

Does SQL Server have anything resembling support for domains that is worth using? Are bound rules are worth using, considering that at least one SQL Server MVP is keeping it alive?

P.S. Don't forget to vote for Add CREATE DOMAIN command ;)


Seems that domain support currently found in SQL Server is not fit for purpose. Best to wait until the CREATE DOMAIN command is added ;)


If I'd venture a guess, data types with embedded behavior (rules, checks, constraints) are better fit for CLR UDTs. You are seeing this already in SQL Server 2008, where some new data types come as built-in CLR types like geography and geometry.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜