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

User Reply | Ask a question | Reply

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

by Thamilselvanj
on Nov 24 2010 5:01AM
Points : 10
Silver ★

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
* Log in, Log out... (1) by Jeeva on 15/02/2012
* Unable to start program and showing Element not found error message in Microsoft Visual Studio 2008 (1) by Thamilselvanj on 19/12/2011
* Error : The request channel timed out while waiting for a reply after.. in WCF service. (1) by Thamilselvanj on 08/06/2011
* How to Split the string in sql server? (0) by Spidy on 19/05/2011
* Error : Sys.ArgumentNullException: Value cannot be null Parameter name: element (1) by Thamilselvanj on 19/05/2011