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 |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2005-01-07 : 04:45:09
|
| Hi All,I need to store data in a table which is more than 8060 bytes. But when I try to do that, it gives me warning. How can I do that without getting any warning. Please help!Thanks in advanceSachin |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-07 : 04:50:32
|
| Split it into two tables joined on the PK or change some of the character columns to text.That's if you can't reduce the size by changing char to varchar or trimming or suchlike.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
Posted - 2005-01-07 : 05:03:50
|
| Thanks NR for the quick reply. But is there any otherway?The software which we are making is a dynamic and generic one. The user of the software can create tables and fields and there datatype. So by spliting tables into one or more tables may lead to confustion. If we make the datatypes as text, the retrival of data will be slower and can be a bottleneck later when the volume of data will increase.Please tell us incase there is any otherway.Thanks in advanceSachin |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-01-07 : 05:15:00
|
| Well there's no way of allowing more than 8060 bytes of data in a row if that's what you mean.>> The user of the software can create tables and fields and there datatype. Usually this is done by holding the metadata in a table and the values in another table. Allowing the user to alter table structures is asking for trouble (as you are findig).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
URGENT HELP!