Need To Know More About: varchar(max)

Question

Need To Know More About: varchar(max)

Gogula G. Aryalingam

SSCrazy

Points: 2688
More actions
June 9, 2005 at 1:00 am

#164743

I need to know more about varchar(max), which is found in Yukon. Please give me some insight and links regarding this topic.
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Have you already looked in the SQL Server 2005 Books Online ?

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Dinesh Asanka SSChampion Points: 11058 More actions · Answer 2

When you use the VARCHAR(MAX) or NVARCHAR(MAX) data type, the data is stored as character strings, whereas for VARBINARY(MAX) it is stored as bytes. These three data types are commonly known as Large Value data types

http://www.informit.com/articles/article.asp?p=327394&seqNum=6&rl=1

My Blog: http://dineshasanka.spaces.live.com/

Gogula G. Aryalingam SSCrazy Points: 2688 More actions · Answer 3

I actually don't have SQL Server 2005 installed on my machine and I tried downloading the Books Online but it's around 110MB in size...

cutespn SSCommitted Points: 1669 More actions · Answer 4

Now varchar(max) holds up to 2GB. To know more abt it, you can check

http://msdn.microsoft.com/SQL/2005/2005Webcasts/OverviewQandA.aspx

HTH,

Sudheer

Regards,
Sudheer

Andrew Forth Old Hand Points: 399 More actions · Answer 5

Hi,

I'm looking to change some existing populated table fields from 'text' datatype to 'varchar(max)' datatype but everytime I try I get a timeout error. I am using SQL Server Management Studio with Yukon Beta 2. I

Any ideas greatly appreciated.