I am importing some data from a temporary table which has a column defined as
VARCHAR(150). The destination tables column is defined as
NVARCHAR(200). I'm using an
INSERT INTO statement, but when I run the SQL statement commenting out this column the query runs correctly. When I uncomment this line, I get:
Msg 8152, Level 16, State 4, Line 26
String or binary data would be truncated.
The statement has been terminated.
Any ideas as to why this is happening?
INSERT INTO table (col1, col2) SELECT column1 ,column2 FROM tmpTable
col1 is defined as
col2 is a
column1 is defined as
column2 is a
When I comment out
col1 the import statement runs fine.