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.
| Author |
Topic |
|
aravindt77
Posting Yak Master
120 Posts |
 Posted - 2009-08-26 : 09:07:57
|
| Hi,What s the size that can be able to handle a column with the data type NVARCHAR(MAX) ??Because I need to store some textual data which may extend to upto 10 pages ...Plz do suggest me if u come accross any other ways to handle Thanks & RegardsArv |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2009-08-26 : 09:11:17
|
| That's what the nvarchar(max) is for.An infinite universe is the ultimate cartesian product. |
 |
|
|
aravindt77
Posting Yak Master
120 Posts |
Posted - 2009-08-26 : 09:22:23
|
| Thanks ,Can anyone tell me how this is managend by sql server , is that stored in single file or a distributed one |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2009-08-26 : 13:46:31
|
| http://weblogs.sqlteam.com/mladenp/archive/2007/07/24/60267.aspxhttp://www.teratrax.com/articles/varchar_max.htmlhttp://weblogs.sqlteam.com/jeffs/archive/2008/05/13/question-needed-not-answer.aspxHow to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxFor ultra basic questions, follow these links.http://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
|
|
|
NVARCHAR(MAX)