Date: 01/04/05 (SQL Server) Keywords: no keywords Okay, I'm confused. I know the length of each field in a table. I'm conforming to it within the select statement (e.g., insert into tableA (columnA, columnB...) select left(column1A,10), left(column1B,10)... from tableB). So why am I getting the "string or binary data would be truncated" error? All columns in the table are character columns, so no integers running out of room or anything. The MDAC2.7 patch has been applied, so it's not the old bug. Source: http://www.livejournal.com/community/sqlserver/13908.html
|