how to truncate text automatically in insertion

Question

Hi there,

my insertion script are sometimes interrupted by length violation issue. how can the overlength text got cut automatically by the SQL Server. We can afford the abruption.

thanks,

Sheldon

Answer 1

If the target column is nvarchar(50), then do something like:

INSERT targettbl(..., col, ...)
    SELECT ..., convert(nvarchar(50), sourcecol), ....
    FROM   ...