开发者

hierarchyid SQL Server 2008

开发者 https://www.devze.com 2023-03-01 03:12 出处:网络
I want to store t开发者_如何学运维he regional information of a customer, for this, I will create the following tables

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

精彩评论

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