Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 column size

Author  Topic 

Mohansoft
Starting Member

6 Posts

Posted - 2005-09-05 : 11:08:47
Generally what is the maximum size a column can have in a table.

D.Mohan Raj

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-09-05 : 11:12:57
varchar holds 8000 bytes.
ntext holds a lot more

BOL has this information under datatypes

Go with the flow & have fun! Else fight the flow
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2005-09-05 : 15:31:23
"varchar holds 8000 bytes"

Unless its nvarchar, in which case the maxmum is 4000 characters

Kristen
Go to Top of Page
   

- Advertisement -