Good day to all!
I have a problem to resolve.
Which is the script in sql in order to define one hierarchy of products categories?
I have need to define the script for the creation of the table and store procedures (INSERT,DELETE,UPDATE,GET,GETALL).
Thanks for the eventual answers !
Search Google for Joe Celko's articles about hierarchies in SQL Server.
You ma yalso be interested in following links:
Joe Celko's book about hierarchies
Article about trees in SQL
Xml is a suitable way to store hierarchies.
So you could define category hierarchies in xml and load it into database.
Hope this helps.
No comments:
Post a Comment