0

Why do i keep getting this error -- any suggestions?

String Or binary data would be truncated

Yogesh Sharma
  • 49,870
  • 5
  • 26
  • 52
Prinzy
  • 15
  • 5

1 Answers1

1

This happens when you try to insert a longer string than a column will allow.

CREATE TABLE t (txt varchar(2))
INSERT INTO t VALUES ('asdf')
Max Szczurek
  • 4,324
  • 2
  • 20
  • 32