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 |
|
sqllover
Constraint Violating Yak Guru
338 Posts |
 Posted - 2007-02-27 : 00:14:57
|
| hi, i have varchar(8000) only acceptsin my colimn.is there any possiblity to insert 10000 words in my row? i am using sqlserver2000. can any one please help me |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2007-02-27 : 00:50:27
|
| No, there is no way use insert more then 8000, characters in a varchar field.. the alternative solutions would be using Text datatype or you can split the word into the len of 8000 characters and insert them into 2 different rows .. based on your id..Chiraghttp://chirikworld.blogspot.com/ |
 |
|
|
sqllover
Constraint Violating Yak Guru
338 Posts |
Posted - 2007-02-27 : 01:08:51
|
| ok chiragkhabaria thankyou |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-02-27 : 01:27:28
|
if you upgrade to 2005, use varchar(max). on 2000 you can use text/ntext
www.elsasoft.org |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-27 : 03:17:25
|
| Are they "words" or "text"?If they are "words", such as Keywords or somesuch, I would store them in an associated table. This will be, for example, easy & fast to search.If they are "text", such as a description or essay, then store them as a Text datatype. This is less flexible to search, and can be harder to manipulate.Kristen |
|
|
|
sqllover
Constraint Violating Yak Guru
338 Posts |
Posted - 2007-02-27 : 03:48:58
|
| hi kristen and jezemine thanks a lot for reply |
|
|
|
|
|
|
what can i do to insert 9000 words in column