Top "Varcharmax" questions

Why not use varchar(max)?

I'm a bit old school when it comes to database design, so I'm totally for using the correct data sizes …

sql tsql sql-server-2008 varcharmax

SQL Server field getting truncated

Ok I'm using SQL Server 2008 and have a table field of type VARCHAR(MAX). Problem is that when saving information …

database sql-server-2008 hibernate varcharmax

SQL 2008 - varchar(max) vs text data types

Possible Duplicate: SQL Server Text type vs. varchar data type Using varchar(MAX) vs TEXT on SQL Server from this …

sql sql-server-2008 varchar sqldatatypes varcharmax

My VARCHAR(MAX) field is capping itself at 4000; what gives?

I have a table in one of my databases which is a queue of emails. Emails to certain addresses get …

sql-server tsql sql-server-2008 varchar varcharmax

SQL server Varchar(max) and space taken

If varchar(max) is used as the datatype and the inserted data is less than the full allocation, i.e. …

sql-server sqldatatypes varcharmax

How can I insert more than 8000 characters in a VARCHAR(MAX) column with ExecuteNonQuery?

I am trying to insert > 8000 characters (submit from a web page) via ExecuteNonQuery (and DatabaseFactory.CreateDatabase() from MS Practices …

c# sql-server-2008 enterprise-library executenonquery varcharmax