0

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

String Or binary data would be truncated

Yogesh Sharma
  • 49,081
  • 5
  • 23
  • 49
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,199
  • 2
  • 19
  • 29