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.
| Author |
Topic |
|
monaya
Yak Posting Veteran
58 Posts |
 Posted - 2009-04-13 : 09:24:00
|
| I was wondering which is better should you place each tag in its own individual record or just place all tags in a single comma delimited record?id tag 254 fun, entertainment, moviesorid tag254 fun255 entertainment256 movies |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-04-13 : 09:40:33
|
| http://www.sqlteam.com/article/parsing-csv-values-into-multiple-rowsMadhivananFailing to plan is Planning to fail |
 |
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2009-04-13 : 09:43:44
|
| Using individual id is the best way to make query easy rather than using CSV,id tag254 fun255 entertainment256 moviesKarthik |
|
|
|
monaya
Yak Posting Veteran
58 Posts |
Posted - 2009-04-13 : 09:55:24
|
| Thanks guys. Seems multiple columns is best. |
|
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2009-04-13 : 09:57:55
|
| yes using multiple column is the normalized form.Karthik |
|
|
|
|
|
|
All TAGS into one column or multiple columns?