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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-06-28 : 09:46:25
|
| Kushla writes "What data type should a Keyword Column be in MS Sql" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-06-28 : 12:17:35
|
| My WAG would be Varchar.-Chad |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-06-28 : 14:04:46
|
| You might want to consider a table an not a column.If you have a object like a Yak you probably want to store keywords like Yak, hairy, smelly, etc. If you store that in a column, you'll wind up with your field looking like this:yak, hairy, smellyIf you make a table of keywords and create a one-to-many relationship between your Object and your keywords it's going to make querying the data much easier and faster.But if you want it in a column, a VARCHAR is the way to go.Michael<Yoda>Use the Search page you must. Find answer you will. |
|
|
|
|
|
|
Keyword Column