How to insert large amount of data into column of a table
-
Hi all, I am using SQLServer2000, I am trying to insert large amount of data into column of a table but i found only part of the data getting inserted into the table. Then i have tried the following option to set the column size sp_tableoption 'testmail', 'text in row', '7000' After the above line get executed its better but still i am lagging behind to store total text .please help me some one Thanks in advance Yuva
-
Hi all, I am using SQLServer2000, I am trying to insert large amount of data into column of a table but i found only part of the data getting inserted into the table. Then i have tried the following option to set the column size sp_tableoption 'testmail', 'text in row', '7000' After the above line get executed its better but still i am lagging behind to store total text .please help me some one Thanks in advance Yuva
-
Hi all, I am using SQLServer2000, I am trying to insert large amount of data into column of a table but i found only part of the data getting inserted into the table. Then i have tried the following option to set the column size sp_tableoption 'testmail', 'text in row', '7000' After the above line get executed its better but still i am lagging behind to store total text .please help me some one Thanks in advance Yuva
Change the datatype to text (or ntext for Unicode). Text stores 2^31 characters, and NText stores 2^30 characters.
Deja View - the feeling that you've seen this post before.
-
Change the datatype to text (or ntext for Unicode). Text stores 2^31 characters, and NText stores 2^30 characters.
Deja View - the feeling that you've seen this post before.
hi Pete O'Hanlon, I have used text data type only but it is not allowing me store whole text(Actually the text in the form of HTml) into my Database
-
the most data you can store in a row is 8000 bytes (so thats 8000 ascii charecters or 4000 unicode). If you need to store more than that you need to chop up the text and store it in multiple rows.
hi originSH , Thanks for your reply but my requiremet is store all the date ito one column i cannot chop up teh thing because i am getting that text dynamically..The text in the form of html Thanks in Advance Chandra Gupta