All geek questions in one place

String or binary data will be cropped error

Using SQL Server 2005

I have two tables that have the same data type and data, as well as the same data

When I execute my query, I got the result in one table, when I execute another table, I got this error, since the row or binary data will be a trimmed error, I also checked the size of this type. Before it starts, I get this error from two days in advance.

I also checked the size of this data type, I changed my data type to 256, but showing an error.

How to solve this problem.

+3
source share
5 answers

You must verify that everything is the same ...

  • To fix a DB?
  • The correct scheme? (e.g. foo.MyTable and dbo.MyTable)
  • ?
  • Trigger?
  • ?
  • ?

: , , ?

+1

, , .

+1

, , . , , , , .

, sql , ( 15 ). , , , - , . Microsoft .

.

+1

, :

If the size of the fields is the same, check the sequence of fields, i.e.

table1:   Address,City,State,ZipCode
table2:   Address,City,ZipCode,State

Inserting into table 1 from table 2 will result in an error.

Another possibility is that the query may perform some concatenation

0
source

If all fields match, then is there a trigger in the table that also includes an extra table with a column too short?

0
source

Source: https://habr.com/ru/post/1727867/

More articles:


All Articles