Top "Ntext" questions

What's the right way to compare an NTEXT column with a constant value?

If I use something like [ntext2] <> '1,032.5', I get this error: The data types ntext and varchar …

sql sql-server tsql ntext

ASP.Net Text with LineBreak from Multi-Line-TextBox to save in a database

I have PrivateMessage-System in my new Community-Page. I have a Multiline-Textbox for the Text of a private message. I save …

asp.net string ntext

T-SQL: Converting NTEXT to VARCHAR to INT/BIGINT

I have a table with a field of type NTEXT which stores many type of values, filesize among them. I'm …

sql-server tsql varchar bigint ntext

SQL Server NText field limited to 43,679 characters?

I working with SQL Server data base in order to store very long Unicode string. The field is from type …

sql sql-server sql-update ntext

The data types ntext and nvarchar are incompatible in the equal to operator

I have a problem and i dont know how to fix it. I have a simple table in database CREATE …

c# asp.net sql nvarchar ntext

Concatenate ntext in SQL Server 2005

I need to concatenate 2 ntext columns into one. I can't convert them to nchar, cause both contains strings longer than 4000 …

sql-server sql-server-2005 ntext

GROUP BY for ntext data

I would like to see how many times the field MSGTEXT is repeated in the table MMOUTBOUND. For that I …

sql sql-server ntext

How to get complete data from SQL management studio for ntext column?

I am using SQL server 2005. In one of the tables, I have a column "xmldefinition" which is of ntext type. …

xml sql-server-2005 ssms ntext

Replace newline in ntext

One of the columns uses ntext. I want to replace the newlines and carriage returns in to space but I …

sql sql-server replace sql-server-2012 ntext