Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Personal tagging

Author  Topic 

caseybasichis
Starting Member

5 Posts

Posted - 2012-04-06 : 11:24:35
Hi,

I've been learning the SQL language for a programming project involving hierarchical relationships.

In the mean time, I have a project where I need to tag elements in a long list with arbitrary tags. I know sql is used for tagging but from what I understand, each tag gets its own table with a list of the id's that a possessed with that tag.

Since I'm going down the list and adding arbitrary tags, navigating to a new table for every tag and inserting the id by hand would be very counter intuitive.

Are there any tools or methods that would make this relatively simple? I was looking at database management tools like sqlitestudio to see if any of them had a capability for inverting the order of work for tagging purposes.

   

- Advertisement -