larger storage than 8000 char 2

[Aeros]

What do you do when you need to store ALOT of text and need to go past the limits of a varchar with 8000 characters?

Thanks

 

[r937]

i use TEXT

r937.com | rudy.ca

 

[mrdenny]

In SQL 7 or SQL 2000 you would use TEXT or NTEXT.

In SQL 2005 you would use VARCHAR(MAX) or NVARCHAR(MAX).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com