开发者

hierarchyid SQL Server 2008

I want to store t开发者_如何学运维he regional information of a customer, for this, I will create the following tables

  1. Country
  2. State
  3. District

But using hierarchyid in SQL Server 2008, I think I can store the information in a single table called Region. Am I right?


If Country, State and District share the same columns than a tree like structure would fit your needs. You could use hierarchyid or just a self referencing foreign key

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜