[error 메모] String or binary data would be truncated.

아래의 오류는 Insert문에서, 여러개의 select한 값을 바로 insert 할 때, data의 길이가 너무 길때, 나타나는 오류입니다.

[ MS-SQL 오류 메시지 ]

String or binary data would be truncated.

 

참고: http://www.devpia.com/MAEUL/Contents/Detail.aspx?BoardID=38&MAEULNo=16&no=3751&ref=3751

참고: error, string or binary data would be truncated when trying to insert

(질문)

1>2>3>4>5>....<1 row affected>
Msg 8152, Level 16, State 4, Server SP1001, Line 1
string or binary data would be truncated.

<1 row affected>

<1 row affected>

(답변)

string or binary data would be truncated 

Think to yourself... The field is NOT big enough to hold my data.