RE: SQL 2005 Management Studio can't edit text rows with > 4000 ch

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

asanford (asanford2000_at_hotmail.com@xxxxxxxxxxxxxxxxx) writes:
I even captured the update query SSMS is generating, and it is NOT
trying to edit the text field, the problem is the where clause that
converts the text field to an > nvarchar(max) to do a like operator
(using an optimistic concurancy pattern.)

Yes, that just seem plain wrong to me. Why not use a simple =? LIKE looks
like a recipe for failure. Note the least with @param1 LIKE '1'...

Of course, with text/ntext/image, it would not work with = neitehr, but
it would work with the MAX data types.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: Problem when changing Views
    ... RecordSource of a Form but in order to speed things up I made into a ... "The Order By clause is invalid in Views ... ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Why Same query results in two different # in SQL Server vs MS Access
    ... it's impossible to tell what the reason might be from ... Move the conditions in the HAVING clause to the WHERE clause. ... Access and SQL Server, ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: what occurs in a comparison when a value is NULL
    ... will evaluate to UNKNOWN and b.ofc is = 1, and the isnull expression ... The next WHEN clause will be evaluated as b.ofc = 0 isn't TRUE here. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Modifying Data Directly through Studio Manager
    ... However, if I do as you say ("Edit a field, click ... or tab to the next field."), ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: MS SQL IF ELSE condition checking
    ... In this particular case, use coalesce: ... clause is true, the value of the corresponding THEN clause is returned. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)