hierarchyid SQL Server 2008
I want to store t开发者_如何学运维he regional information of a customer, for this, I will create the following tables
- Country
- State
- 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
精彩评论