Home > Forum > Sql Server > Sql server data type for store large text, xml or resume using sql server 2000

Sql server data type for store large text, xml or resume using sql server 2000

by Thamil   on Nov 24, 2010   Category: Sql Server  |  Views: 4045    |  Points: 5   |  Gold 
  Reply
I have a requirement to store large amount of data (string/xml/anything it may be)
from 4000 to 30000 characters in a particular column of SQL server 2000 table, which data type (varchar, text….) is best to store this kind of large text.

Regards,
Thamilselvan J.

Bookmark and Share:
 
  User Reply  | Ask a question  |   Reply 
  Re :Sql server data type for store large text, xml or resume using sql server 2000   
by Thamil
on Nov 24 2010 5:01AM
Points : 10
Gold 
SQL server 2000 provides the TEXT data type which is used to store such large content in the table. In SQL server 2005 provides the VARCHAR(MAX) data type for store large content.

Below is the sampel code for TEXT data type

CREATE TABLE dbo.TESTTABLE
(
TEST_ID INT IDENTITY(1,1) NOT NULL,
TEST_TXT TEXT
)

Below is the sampel code for TEXT data type

CREATE TABLE dbo.TESTTABLE
(
TEST_ID INT IDENTITY(1,1) NOT NULL,
TEST_MX VARCHAR(MAX)
)


Thanks
Thamilselvan J.

Recent Post

Latest Posts