varchar(max) in sql server 2005

vinchellam · May 29th, 2007, 05:04 AM

how to use varchar(max) in sql server 2005 and doesn't support varchar(max) in sql 2005

vinoth

happygv · May 29th, 2007, 07:42 AM

How did you use that ? can you post here your code that you tried?

_________________________
- Vijay G
Strive for Perfection

vinchellam · May 30th, 2007, 02:48 AM

declare @content varchar(max)
create table <table_name> (nam varchar(max))

vinoth

happygv · May 30th, 2007, 03:27 AM

I dont understand what you mean "it doesn't support", do you see any errors? IF so whats that?

This always works in SQL server 2005

Code:

CREATE TABLE BigStrings
(
    BigString VARCHAR(MAX)
)

Both your statements work good in sql server 2005

_________________________
- Vijay G
Strive for Perfection

sshelper · May 31st, 2007, 10:32 AM

If you are getting an error when you declare a variable as VARCHAR(MAX), maybe the database you are connecting to is not really SQL Server 2005 but SQL Server 2000. You may be connected to a SQL Server 2000 database from SQL Server 2005 Management Studio.

For other FAQ about VARCHAR(MAX), refer to the following link:

http://www.sql-server-helper.com/faq...r-max-p01.aspx

SQL Server Helper
How well do you know SQL? Find out with the free test assessment from SQL Server Helper!!!
http://www.sql-server-helper.com/free-test/default.aspx

Got a SQL Server Question? Ask us here: http://www.sql-server-helper.com/forums/default.asp